I am using FM pro advanced on mac. I have one table with supplier data and need help.
A supplier can be in a certain city so I search on city first by typing that in in the find mode.
Then I want to narrow that search down by using a drop down list with names of suppliers in that city only.
My problem is when I go to find mode I get a list of every possible supplier in my data base and not related to the city I typed in already.
your help is appreciated.