+Selecting a table to query

[WAVP375]

Lets start at the top. I have changed the design to a single table. It has a primary key of 'Autonumber'. There will be name appear in any or all of the events, therefore the event number and badge number makes the record unique within the event and the autonumber makes each record unique in the total record set. Any of the records will need to be updated at any time. My approach is to select the event from a listbox bound to the TblEventNames which contains Event number, Event Name and Date and location. Once an event is selected, use that event number to filter the attendees name from the TblVolNames and populate a listbox. Selecting a name from the listbox will populate the update form, on which the listbox resides, allows changes and save the updated data.



Sounds fairly straight forward. I have tried different approaches and nothing works. Is this a reasonable approach or can a different one be suggested?

[davegri]

I have changed the design to a single table.

But you mention two tables. Would you please show us a jpg of your relationship diagram and your form?

[WAVP375]

Tell me how, I will send you the entire database.

[orange]

https://www.accessforums.net/faq.php...b3_attachments

[WAVP375]

The DB will not upload.

[CJ_London]

before sending, compact it, then zip it then upload the zipped file

[WAVP375]

Look for it in new thread by same name.

Thanks