a way needed to select data to fill a sub-form

[Russ Neuman]

I do not use either "an ADO connection in code, or the opendatabase() method". The Link Table Manager pulls in the data very fast and good with impacting the performance of the other DB.



My problem is I need the little bit of tricky code to

check my DB-A's plainid the DB the user is in. To check the DB-A's planid against DB-B' plainid then use the data to fill a sub-form. If there is not a match go to DB-C and use that data to fill in a sub-form.


The sub-form data is for display only, not to update.



RUss

[MMcCarthy]

Russ, you will have to give a lot more information on the background to this database. It's impossible to follow your meaning from the information you have given.

Are DB-A and DB-B different databases or what?
Is planid a way to uniquely identify the user, database or what?
If we are talking about different databases are they all linked to the same backend?