Create One Record in a New Table from several tables

Create One Record in a New Table from several tables

Post by REYyMDA » Thu, 10 Jan 2008 03:00:03


I have 4 "master" tables of information - Agent, City, Dept, and Level. I
have a form that has a list box for each field in each of the 4 tables [4
fields total].

What I need is: The User clicks to select the field information needed in
each of the 4 tables, then I want them to hit a command button and it creates
a new record in another table with the selected information.

Can anyone help me?

Would greatly appreciate it!
 
 
 

Create One Record in a New Table from several tables

Post by John W. Vi » Thu, 10 Jan 2008 07:03:38

On Tue, 8 Jan 2008 10:00:03 -0800, DF2008 < XXXX@XXXXX.COM >



It sounds like you may be working backwards! The tables come first; the form
is just a tool to enter data into the tables.

Base your Form on the table which is to contain the data; set each listbox's
RowSource to the appropriate master table, and its Control Source to the field
into which that value should be stored. No code and no button needed - Access
will create the new record with the selected values as soon as you move off
the record.

John W. Vinson [MVP]