I have 2 databases: CUSTOMERS and CUSTOMER_PRODUCTS
1) CUSTOMERS contain the customer header records such as customer_name, address etc.
2) CUSTOMER_PRODUCTS contains images and descriptions of the products that each customer sells.
Both databases contain a unique value for CUSTOMER_ID that logically links the 2 databases together.
On each screen, I want to display 1 customer record from the CUSTOMERS database followed by a gallery of images of that customers products from the CUSTOMER_PRODUCTS database.
Help! Is this possible? I dont find any docs on linking databases together?