Adding a group of new records to a subtable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple contact management database. I'm working with two tables,
[tblAgencyLocations] and [tblContactLogsub]. I sent out 300 direct mail
pieces and I want to record that in tblContactLogsub. The two tables are
linked with a one to many relationship using the Field [LocationID]. I can't
seem to figure out how to do this. Help would be greatly appreciated.
 
1. Create a query.

2. Change it to an Append query (Append on Query menu).
Access adds an Append To row to the grid.

3. Type the values you want into the Field row, choosing the field it be
added to in the Append To Row.

You can now run the query (Run on Query menu.)

Alternatively, if you want to automate this process and you are comfortable
with code, you can switch the query to SQL View (View menu), and use that as
an example to build up a string in VBA code, and then Execute the string.
 
Thanks Allen, that did the job!!!!!!
--
Steve Belchik


Allen Browne said:
1. Create a query.

2. Change it to an Append query (Append on Query menu).
Access adds an Append To row to the grid.

3. Type the values you want into the Field row, choosing the field it be
added to in the Append To Row.

You can now run the query (Run on Query menu.)

Alternatively, if you want to automate this process and you are comfortable
with code, you can switch the query to SQL View (View menu), and use that as
an example to build up a string in VBA code, and then Execute the string.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Steve Belchik said:
I have a simple contact management database. I'm working with two tables,
[tblAgencyLocations] and [tblContactLogsub]. I sent out 300 direct mail
pieces and I want to record that in tblContactLogsub. The two tables are
linked with a one to many relationship using the Field [LocationID]. I
can't
seem to figure out how to do this. Help would be greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top