Thread: Database Help

Hello,

Im wondering if anyone can help me.

Im new to access and have read up on my normalisation documents etc.
I've taken all my data and split into tables that I think are logical.

I have images that shows my visio diagram of tables and an example of what I want my form to look like.

The databse is used for logging Fund Activity.

• 1 activity can have many funds associated to that record.
• Each Client and Fund Type combination has a tier1 and tier 2 profile associated with it that will be used for calculated fields on a form.
• Activities should only be added to the Funds table if the Activity Type is a "Launch"

I am looking for help on setting my form up so that when I add a new Activity I have a subform that I can add fund information in (like the example jpg)

I only want to commit these subform Funds to tblFunds as inactive, if the Activity Type is a Launch.

Any other Activity Type should have the option to add the funds in the subform so that they can be associated with that specific activity, however, not commited to the Funds table.

So to give more information, lets just say for example the Funds table is empty along with the Fund Activity Table and the Activities table.

I go and add a new record through the Activities Form. The Activity reference is auto numbered as 1.

I select the Activity Type as a Launch.

In the subform I would like to add 2 fund codes so add Fund BM01 and BM02 with names Brian 1 and Brian 2. I dont want these Funds to go to the Funds table until I press a button such as save record at the same point on the Fund Activity table would have records for Activity 1 and Fund BM01 and Activity 1 and Fund BM02.

The funds table now has BM01 and BM02 aswell with both showing as inactive.



Say I then go and add another record. Auto Numbered as 2.
This time the Activity Type is a Transfer In.

In the subform I add Fund BM01.

On the Save Record button the Fund ID is only sent to the Fund Activity Table.



I hope you understand what I am trying to achieve.
I have attached copy of database and my images.

Any help or comments greatly appreciated.

Thanks

McC