Balancing issue on access

[shree]

Hi all,

I am going to create one database which is required for share portfolio i have made three table with one to many relationships
see the below, i confused in, i want to total of each security, each broker and till date that i want e.g end date <=ve

in broker filed i several brokers i want to create forms which shows as each broker position or current balance which date i select

please help me its so urgent because.... my Currier...

	TABLE - INFORMATION		TABLE - ENTRY		TABLE - TABLE1
	SR NO - PK		ENTRY NO - PK		BROKER ID - PK
	FUND		CONCATENATE		BROKER NAME
	CUSIP		BUY
FUND +CUSIP	CONCATENATE		SELL
			ENTRY DATE
			BROKER ID
			BROKER NAME

CONCATENATE IS ADDITION OF TWO FILED FUND AND CUSIP FOR MAKING UNIQUE VALUE

[Robeen]

Shree!
I tried to understand - but it is very difficult to understand what you are trying to explain.
Can you explain in different words?

[alansidman]

In addition to Robeen's comment which I concur with, I noticed that you have repeated the Broker Name in the Entry table. This is extraneous information as you already have it in the Broker table. In your table information you have a concatenate field that is not necessary as the data is already in the table in the two fields. This type of information, (calculations) should be performed in queries on the fly as needed. Calculated data is not normally stored in tables in a relational data base.

[shree]

Hi Alan,

Apologies for communication!!

My first table for adding a new securities that is information table, and second one for adding entry of Buy or sell event for the securities and which broker contain,

there are mainly brokers if new broker is taken place so i can add into third table on our database third table is not for just adding new broker information's.

and my question is : i want to create on balance Forms which can gives me the individual broker total balance. e.g. GSAM - -10000 2) BPN - 30000
like that and criteria that security which i select and date at this date my balance is blabalabal

means if i Type my security concatenate on forms and date select the date which i want to know the my position held at individual broker

i hope you understand,,,,, please advice and thanks a lot for you previous reply!!!