Lookups, queries, and combo boxes, oh my
Windows Vista 
Access 2007
I haven't done anything with Access since Access 97...so I'm really rusty and never was a super user, but I can be taught!
I don't think this is real difficult but I can't seem to figure it out.
I'm making a database to track projects/opportunities. I have a Project Data table, a customer table, and a contact table. A customer can have multiple contacts. I have already figured out how to use a lookup in the Project Data table to be able to select a customer for the project but how do I then select a contact based on that customer? I want to be able to assign a "main contact" in the project data table based on the customer that is selected. I can't seem to figure out how to use the customer selected in the project data table to provide only the contacts for that customer to be selected from a combo box in the project data table.
Reply With Quote
