How create an easy way to link to two backend tables in a different Access database file
I have two BE tables that I normally link to that the rest of the BE tables reside in. But I'm trying to figure out how to use a form to link to the two tables, (they have the same names as the ones I'm normally linked to), instead of the ones within the working BE file.
I think I'm doing a terrible job trying to explain this one.
In other words, on an every day basis I have a FE file and a BE file. The FE file contains linked tables to the BE file. But in some cases I may want to link two of the tables to the two tables in a different BE file.