I am completely new to Access... period! Please bare with me if I am not plain in the way i ask. I have (1) single form (CUSTOMERS) and on the top of this form i have a list box that is populated with all of my current customers. Below this list box are tabs.. Quotes, Orders, RMA, Notes,etc. I have embedded a list box for each tabbed page.
When a line of customers in the list box up top is highlighted... i would like for the tabbed pages below to reflect that customers list of past Quotes when that tab is selected, or Orders when that tab is selected...so on and so on! I love figuring this stuff out for myself if i can be pointed in the right direction. I don't know if i need an individual table for each customer and each quote and order and so on... but I am looking for help on this as I am attempting to develop my own management program for a business start up.
Any help available?