As you can see, there are multiple ‘Ubermachts’ for example in the dropdown. Below is my database, showing the multiple ‘Ubermachts’ entries:
What I’m wanting is ‘Ubermacht’ and other makes like it to appear in the dropdown only ONCE even if their are multiple database entries with the make ‘Ubermacht’, for example. Then the dropdown beside it shows models that only are of the make, ‘Ubermacht’. I have this working.
Any advice on how I can get the make dropdown to show the make once even if it’s in the database more than once?
Looks like @keith’s post got you where you need to be… that post is pretty darn awesome, eh?
If I understand your setup correctly, @lynx.hub.pro, I believe the source for the first dropdown needs to be Search for SADMV Vehicless Vehicle Make:unique elements… so just a slight tweak to what you have now.
Yes, I appreciate his help in switching the data fields. Unfortunately however when I try the ‘Search for SADMV Vehicless Vehicle Make:unique elements’ I’m getting an error where it’s trying to switch the type of choices to ‘text’ instead of ‘SADMV Vehicless.’
I feel like if I understood :unique elements better in this context I could solve this, but I’m still a little lost?
Well, at least I know I’m not crazy… when I responded the first time, I was thinking, “Why isn’t the source for the first dropdown just Search for Vehicle Makes:unique elements?” Alas, I talked myself out of that because I think I misread Keith’s other post, and I thought it was ideal to do both searches off of the SADMV Vehicles table.
Oh, well… enlightened by Keith again… thanks, man!
I want to thank @keith and @mikeloc for your help! I was able to implement the solution to my problem. It’s encouraging the help I received so fast from the community. I hope to keep learning, thanks guys!