So here is what I’d like to do.
I have a base with four tables. All look precisely the same in terms of fields (types and names).
For your understanding, the first three tables are lists with data about particular individuals. And the last table includes all individuals.
My goal is to create a field on the fourth table that will let me know by the person’s “Name” (which is the first field) in which table he/she is located.
But, some of the records repeat themselves in different tables, so I’d also like to know if the record is in “table1” and “table 2”.
Thanks In Advance,