Add one record from table B to table A

[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.

 

[John Vinson]

I need some help adding a record to a table with a lot of columns.

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.

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.