Search options

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.)

Sorry for posting a new topic again, but it had nothing with the former topic to do.

Anyway! I've tried a couple of times to change a text field height to 100 instead of default 21, but as soon as I try to run the application the field is back at 21.

I want a field for notes with multiple lines, is this possible?

How do I configure my search field to be able to list a result with maybe one or two letters entered in the search field?

For example. If I put in just a letter "A" in the search field and press the search button. I want the table to show all names starting with A. As it is now I have to enter the whole name to display it in the search field. Entering just the first letter or perhaps two, result in a blank table.