Referencing a separate table

Mocha Float

New member
Local time
Today, 13:52
Joined
Feb 15, 2013
Messages
9
Hello,

I'm working in the Before Change data macro of a table (call it table A) using a For Each Record loop in table B. table A has a field that contains ID's of records in table C. I'm trying to check if a certain value in table B is equal to a value in table C with a corresponding ID from table A. My question is:

How do I reference the value in table C that corresponds to the ID (which I know) from table A?

PS: This is in Access 2010 Web
 

Users who are viewing this thread

Back
Top Bottom