Table Question

[lskuff]

I have a question. I have a table called Attendees and another called SeminarAttendees. The Attendees form has just a list of all the Attendees' information (name, ssn, address, etc) and the SeminarAttendee form has other information. I need to add the SSN from the Attendee form to every attendee in the SeminarAttee form. Some names are the same so I can't use a querry joined like that. Any help?

 

[llkhoutx]

You have a fundamental design problem. Your tables are not normailized. You should have a single table with names. The seminar attendee table should have ID identifying the seminar and the attendees (with a name id).

 

[lskuff]

Sorry, I don't think that I explained myself quite right there. I do have an AttendeeID that each attendee is indexed by. But when I do a querry to get the SSN from the Attendee table it does not work. What happens is in the SSN field of the SeminarAttendee I have a combo/list box that drops down with all the social security numbers. Thanks!

 

[llkhoutx]

Attached is a zipped simple Access 97 solution to what I think is similar to what you're doing.

This should give you an idea. Look at the tables, the query, the form and the subform.

Your posting isn't clear if you add names on the fly. My solution appears to allow it but it doesn't because you have to post info to two tables, each time a new attendee is added. I didn't code that.

If this doesn't help, post a mdb of what you're doing.