Help with Access 2007 tables

[Eric]

Hi. I would like to know how to add fields of other tables in the same
database to a new table. i tried using the add existing fields option but it
seems to add them as a lookup list which is not what i want. i want them so
show up under each other in the table. please help. help greatly appreciated.
thanks

 

[Michael J. Strickland]

Hi. I would like to know how to add fields of other tables in the same
database to a new table. i tried using the add existing fields option
but it
seems to add them as a lookup list which is not what i want. i want
them so
show up under each other in the table. please help. help greatly
appreciated.
thanks

One way I know to do this is:

1. Open the destination table and add an empty field (e.g. FIELD1).

2. Close the destination table.

3. Open the source table and select the entire column (field) you want
to add.

4. Hit Ctl-C (copy).

5. Minimize the source table.

6. Open the destination table and select the new, empty field (column)
which you added in Step 1 (FIELD1).

6. Hit Ctl-V (paste).

7. Close the source table.


--