Entering data from a table into a form.

[He cries for help]

I have created a form to enter data into a table called "abcd",
I have also imported data into a table called "efgh" from a excel spread
sheet.
I want to take data from table "efgh" and enter this data into certain
fields for storage
into the table called "abcd".

I know that the information is already in the "efgh" but I have to complete
the balance of the the fields in real time and need the information for
record keeping and objective evidence.
I am using access 2003

 

[John W. Vinson/MVP]

I have created a form to enter data into a table called "abcd",
I have also imported data into a table called "efgh" from a excel spread
sheet.
I want to take data from table "efgh" and enter this data into certain
fields for storage
into the table called "abcd".

I know that the information is already in the "efgh" but I have to complete
the balance of the the fields in real time and need the information for
record keeping and objective evidence.
I am using access 2003

Insufficint information! How can you tell which record in abcd relates
to a given record in efgh? Is it really necessary to copy the
information (redundantly!?) into a second table, or can you just use a
Query to join the two tables?