Dynamic Data for Menu
Just want to say that the software really does make if wonderful for a novice like me. Could you help me with the following:-
1) My Menu is Pulling from a Field but It is pulling multiple copies of the same item( how do I make it call one - i think the word "distinct" has something to do with it but I'm still learning. Example Customers ay have a Ford, Vauxhal, Peugeot, Honda Ford, Mazda - but i want the list to only show 1 Ford.
2) Once the Make is Selected, I want my next field to filter a populated list of the models specific to ford - ie instead of listing all models it needs to automatically filter to ford models example - Mondeo, Astra, 406, civic, Kuga, 626
If the Customer chooses the Ford (Make) from the 1) List, then the next field (models) from the 2 list will filter Mondeo, Kuga.
I hope I make sense with this - I spent a whole day yesterday trying to make it work. Please help!