BrotherBook
Registered User.
- Local time
- Today, 06:18
- Joined
- Jan 22, 2013
- Messages
- 43
I have an access front end for a SQL database and I have created a Call Records Table and a Call Attendees table. On the Call Records table I have two unbound Listboxes, "AvailableAttendess" and "CurrentAttendees". Available Attendees is a not inlist query to the Call Attendees table so that any previously added Attendee is not shown, while the Current Attendees listbox queries out any current attendees from the Call Attendees table.
I run into an issue with new Call Records as the form is not generating an autonumber ID for the new Call Record prior to attempting to add new Call Attendees.
When does Access create that new ID #, and is there a way for me to force access to do this?
I run into an issue with new Call Records as the form is not generating an autonumber ID for the new Call Record prior to attempting to add new Call Attendees.
When does Access create that new ID #, and is there a way for me to force access to do this?
