That is the scenario that you are supposedly facing. You can tackle the last problem first. First of all, your entire solution can be handled with one form. To query another database, consider the IN clause that you can either run from a RunSQL action or directly as a row source. Here is a typical SQL statement:
SELECT * from Customers;