BrotherBook
Registered User.
- Local time
- Today, 11:20
- Joined
- Jan 22, 2013
- Messages
- 43
Hi-
I have a form called "Record Call" when a user can input the calls that they have made or are scheduled. This form is based on the table "CallRecords". I have created a new table called "CallAttendees" and added a listbox to my form for users to select who attended/participated in the call.
My code loops through the selections and writes these selections to the "CallAttendees" table. In this table i have an auto #, CallRecord, and Attendee fields. My code is supposed to write the "ID" field from the "Call Record" table to the "CallAttendees" table so that i can create the relationship between the two tables. However, this field is coming up blank since my form isn't generating the auto # until the record is closed.
The tables are stored in a SQL server. I also tried saving the record prior to running my code, but that didn't help.
Any help to get this relationship to work would be helpful.
Mike
I have a form called "Record Call" when a user can input the calls that they have made or are scheduled. This form is based on the table "CallRecords". I have created a new table called "CallAttendees" and added a listbox to my form for users to select who attended/participated in the call.
My code loops through the selections and writes these selections to the "CallAttendees" table. In this table i have an auto #, CallRecord, and Attendee fields. My code is supposed to write the "ID" field from the "Call Record" table to the "CallAttendees" table so that i can create the relationship between the two tables. However, this field is coming up blank since my form isn't generating the auto # until the record is closed.
The tables are stored in a SQL server. I also tried saving the record prior to running my code, but that didn't help.
Any help to get this relationship to work would be helpful.
Mike