Hello,

I dont know if this question rightly belongs to Relationships or not.

I have created a database with two tables which are related by a unique ID.

In the first table I have certain specified information - such as Name of the person, DOB, Unique Number etc

In the second table I have information of what items were performed, Date of Performance, Unique Number

Each Person may have number of dates of performances and on each of those dates - number of items will be selected (from 1 - 20 items)

At the moment the database is working well as for reports I am using the primary table as the baseline and extracting data from the item table by a Portal and it seems to do well.

The question I had was related to data entry

When I am inserting data - I have two forms

One for the first table for the Name, etc

one for the second table for the date of performance, items performed etc

But when I am inserting data in the second form, I have to enter the Name, Unique ID all over again. Can I by some way set up those fields to gather information from the first table. Which means that as soon I enter the information in the first form and then press the button enter item details - it kind of assumes that the person that I am entering the item details is the same as that i have entered in the first form and I just have to fill the extra details such as the item details, date of items etc

Any help would be great

Thanks

I have been able to understand this and use this in my database

Thanks