Add one record from table B to table A

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

I need some help adding a record to a table with a lot of columns. I have a
second table with records that have some of the standard columns populated.
I would like to select a record in table B and add it to table A then invoke
a form to add the remaining fields or select a record from Table B and
populate many of the fields in a form already used to add records to table A
and allow someone to fill in the remaining fields then add the record.



Is there an easy way or even a hard way, where I can see an example of this?
Thanks.
 
I need some help adding a record to a table with a lot of columns.
Click to expand...

What's "a lot"? If you have more than some 30 fields in a Table, you
should really be asking whether your tables are properly normalized!
VERY few entities have more than that many distinct, non-repeating,
atomic attributes.
I have a
second table with records that have some of the standard columns populated.
I would like to select a record in table B and add it to table A then invoke
a form to add the remaining fields or select a record from Table B and
populate many of the fields in a form already used to add records to table A
and allow someone to fill in the remaining fields then add the record.
Click to expand...

You can run an Append query appending one (or many) records from
TableA into TableB, and then open a form based on TableB... but I
really must wonder if the problem doesn't lie in the table design.
Storing the same data redundantly in TableA and in TableB makes me
VERY queasy.
 
Back
Top