The application I need would link 3 different databases: 1. A customer database of contact information 2. A database of digital ID codes (4-character alphanumeric strings) assigned to customers 3. A database of hardware devices sold to customers The the common “key” for these three databases is the customer ID. Most customers purchase 3 digital IDs and various pieces of hardware, adding hardware over time. When we sell a new piece of hardware, it must be programmed with the correct IDs for the customer who has purchased it. When I add an item to the hardware database, I should be prompted to assign it to a customer in the customer database, preferably by choosing one by name from a list. It should then also notify me of all digital ID codes (alphanumeric strings) that belong to that customer. Similarly, we should be able to search for a digital ID code and see which customer it is assigned to, and what devices it has been programmed into. When we sell a new piece of hardware, we look up the customer, and available IDs are filled into a form. We then program those IDs into the new hardware with a customer program we have written already. Is there any way the list of IDs can be automatically sent to our Windows app? Ideally, when a new piece of hardware is sold, the following steps would take place: - The customer is found in the database, or added (if the customer is new). - The IDs assigned to that customer are returned to us(and/or new IDs are added and assigned to them if required). - Model/serial number/version and other information about the new hardware being sold is added to the hardware database, and associated with the selected customer. - The new item hardware is connected to the PC for set up. - The “Program” button is clicked and the IDs that belong to that customer are programmed into the unit. - A document outlining all of the above is printed out – customer info, device info, IDs, and the date the process was completed. - The hardware device and the printout are passed to the shipping people.