Combining two fields from two tables

[Guest]

I need to combine two fields from two related tables in another field using a Form. The combined field is the primary key using two fields to make it unique. In the form I woud like to use SQL or code to automatically input the data in the combined field after entering data into the two fields used for the primary key

Please help!

 

[Larry Linson]

Two fields from two related tables... that's easy enough to obtain with a
query that joins the two related tables, assuming you want the fields from
"matching" records. On the other hand, if you want to _select_ the
combination, that's a different matter.

What type of field are they? If not text, then how, exactly do you want to
combine them? If text, will one just be appended to the other?

How do you plan to use the combination? If to uniquely identfy a record in a
third table, you are likely better off to just store the two fields
separately.

Clarify and perhaps someone can be of help.

Larry Linson
Microsoft Access MVP

I need to combine two fields from two related tables in another field

using a Form. The combined field is the primary key using two fields to
make it unique. In the form I woud like to use SQL or code to automatically
input the data in the combined field after entering data into the two fields
used for the primary key.