Just starting and I could use a hand - Dropdown list problem
Hi, I'm just starting on my first FM database. It is very simple but I seem to be stuck. Here is my problem.
I have 2 fields. Field 1 would be manufacturer and Field 2 would be product.
I would like to make them both to be drop down menus.
When you choose a manufacturer in Field 1 you will only see that manufacturers products in the Field 2 drop down.
I would think this is pretty easy to do but I just can't figure it out.
Thanks for your help.