Sub forms and tables

[Guest_imported]

Hello,

I'm working on simple databse right now that logs volunteers, the activities they'vew done and the area they've worked.

One table(SignIn_data) keeps track of the person, date and time. Activites and Area logs are kept in two different tables.

The user selects a activity/area from a sub form. This sub form puts the Activity and their SignIn number in the table.

The problem is that the SignIn number doesn't get recorded if they haven't signed in before.

Does anyone think they might know what is wrong?

Thanks in advance

Gary

 

[dawnd3]

Is the sign in number generating a new ID number? (Is sign-in the primary key?) I am just wondering, if the sign-in number wasn't a auto-number (but a user entered number) then there wouldn't be a record if they hadn't signed in before (so only the existing sign-in numbers would like up to the subform.) Am I even on the right track? Dawn

 

[Guest_imported]

Thanks for the reply Dawn!

The SignIn ID is not the primary key. It's a auto-number that tracks how many people have signed in there have been.

The primary key is a MemberID for the volunteers. I can't use that because it'll overwrite previous entries if the MemberID's match.


Thanks in advance

Gary

 

[dawnd3]

I have to admit, I am a little lost on this one. I need you to describe your table structure a little better. Please tell me what fields are in each table (necessary to this issue) and what the primary keys are and how the tables are linked. Also please tell me what is the control source of the form and the subform. Thanks Dawn