I have designed from scratch a database that I've been using successfully for years. When I upgraded to FMPadvanced 11 and imported the database, it didn't work. All attempts failed. At that point I decided to just use exisiting starter templates.
I am running a business that manufactures product, each piece has a unique item number. I am using the "invoices" template with a problem that I cannot change. I've tried everything I can think of. In the "product ID" field, I want to change it from "drop down", or any of the other choices, to an entry field. When I enter the item number, I want it to auto fill the information supplied from "Products". As it is, It automaticaly assigns a serial number along with a part name that I provide. It's driving me mad, and it worked perfectly in my previous database.
Any help would be greatly appreciated!