megatronixs
Registered User.
- Local time
- Today, 05:23
- Joined
- Aug 17, 2012
- Messages
- 719
Hi all,
I'm trying to get a create a nested dlookup as I think this is what I need.
not sure how it works and all examples I can find are not relevant to what I need.
I need to compare 1 field from 1 table to another field from a second table, I the record is also on the second table, I should get a true, false if not.
I'm using right now 2 test tables for this purpose:
table_1 and table_2. the field names are not equal on both. First table has "walk_1" and second table has "second walk"
Any idea how this can be done? from my understanding "DLookUp" works only on 1 table, and a nested can be used for 2 tables.
thank you all in advance.
I'm trying to get a create a nested dlookup as I think this is what I need.
not sure how it works and all examples I can find are not relevant to what I need.
I need to compare 1 field from 1 table to another field from a second table, I the record is also on the second table, I should get a true, false if not.
I'm using right now 2 test tables for this purpose:
table_1 and table_2. the field names are not equal on both. First table has "walk_1" and second table has "second walk"
Any idea how this can be done? from my understanding "DLookUp" works only on 1 table, and a nested can be used for 2 tables.
thank you all in advance.