I am working a form to email and I have come across a conundrum. The table that is the record source for this form has a lot of data that can go into this form, but all of the data
there is insufficient for my form. I need at least another table.
The only way to do that I think is a query that pulls two tables together and can be used for a record source for this form; not just the one table that I had originally used.
However, you can't just start adding tables to a query willy-nilly, or higgedly-piggedly. No sir. The these two table are in the same db, but what else must they have in common that would allow
them to be used in a query?
Any help appreciated. Thanks in advance.
Respectfully,
Lou reed