Append multiplie fieds from one table to main table

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hi'

I need to populate fields using small table to a main table, so instead
typing the same information over and over I want to use some sort of combo
box to populate the same fields.

tks
jg
 
Joe said:
Hi'

I need to populate fields using small table to a main table, so
instead typing the same information over and over I want to use some
sort of combo box to populate the same fields.
Click to expand...

If the small table contains something like RecordKey, Name, address, phone
number.

All you have to do is store the RecordKey in your main table and use a query
to show the information from the small table.
Your combobox would display the info from the small table and store the
smallTable.RecordKey in the MainTable.RecordKey.

There may be valid reasons for not doing it this way but those are rare.
 
Back
Top