YES/NO Column

R

Rick

I am new with access and I have a simple question. I have
two tables. TBL1 and TBL2. A field called mach_id is the
primary key in each table. I have a YES/NO Field in TBL1
that I want Access to assign YES if that specific mach_id
exist in TBL2. If the mach_id does not exist in TBL2 I
would like a NO. Can anyone one please help me? Thanks
in advance.
 

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

Top