I have a database with various fields in it...
One of the fields has town/city, the next one has county/state and the final one has country. All these fields are drop down lists with edit.
What I would like to do is to 'conect' some of these fields up.. What am I talking about?
If I enter in the City field 'Johannesburg', I then have to enter, in the next field 'Cape' and then in the final field I enter 'South Africa'..
If there a way to 'tell' filemaker that if I click on 'Johannesburg' it knows to auto enter ' Cape' in the next field and 'South Africa' in the final field?
I am using Filemaker 11Pro on Mac OS 10.6.5
Thanks for any help that you can give me..