Topic: Stuck with my program, need ideas/help.
Okay, so I'm creating a database for myself to use at work to store my customer specific product information. I want to be able to search a customer, click it and then select at which department/address (if the same customer has more than one department or address) and after choosing address I want to display the products that has been created for that address.
I'm almost there, but quickly concluded that I missed something. So as it is now I have to create a whole new customer to add an address for the same customer, so the same customer but different address, lists as a whole different address.
My combobox with addresses also lists all addresses that I've added and not just the ones that belongs to a specific customer.
I've attached the database as a zip.
Please help me figure it out. (I've translated everything to English from Swedish, that's why buttons are either to short or to long.)