I’m trying to develop an Access database. Among other things it contains account numbers and company names. Each account is unique to a company and the company can have more than one account. I have a table that contains each account and its associated company. I have a form to input information but I want to input just the account, not the company name, saves time. When I run a report I want to include the company with its associated accounts. How do I link the accounts with the company? Through a lookup table in a query? How is it done? Thank you all for your help.