IIF to check values in more than one table

G

Guest

Hi,

I want to put a control onto a form that will tell me if a record has a
matching record in another table. I know I can use a query, the unmatched
query wizard (to see which records don't), and the find duplicates query
wizard (will tell me which records are duplicated in a table on a given
field), however, I would like the control to simply give me a yes or no
answer when comparing the ID of the current record to the Record IDs in a
matching table.

Any ideas?

Many thanks,

Karen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the date on one form to limit the records from another table 5
Table Splitting Questions 7
Table Design Question 3
Adding records with referential integrity 7
Trying to combine multiple records into one record in a Query 0
Store similar types of records all in one table or separate tables? 2
field that checks if the primary key value appears in a related ta 3
NOT IN (SQL) or Find Unmatched (+ other stuff) 21

Top