Database update from forms by user

[PBL]

Hi,

Could someone help ? Is there a way of allowing user to reference/update from either databases ? If user enters an item code and it is not found in database A, can the program direct it to retrieve/update from/to database B ? Assuming database A and B are item databases with different contents.

Thank you and best regards
PBL

 

[JHB]

Example from the Help-file.

The following table shows how you can use the IN clause to retrieve data from an external database. Assume the hypothetical Customers table is stored in an external database.

External database:​

Microsoft Access Database engine database

SQL statement:​

SELECT CustomerID FROM Customers IN OtherDB.mdb WHERE CustomerID Like "A*";