General Lookup Field Question
I am assuming??? that look up fields only work with directly related tables. And will not work with many-to-many relationship Table 1 to Table 3?
It is possible to copy data from a related table that is more than one Table Occurrence "away" from the field's table occurrence. But it depends on the relationship and (possibly) what auto-enter options you selected to make the look up happen. (If by "look up" you mean setting up one field to automatically copy data from a related record.)
Retrieving data ...