Hi all,
I am expereincing some troubles with comboboxes that share related data.
The best way to explain this would be to say we have three combo boxes (country, province_state, county).
These 3 fields are located within the same table.
When the user selects country, it fills in the id, and uses a relationship to gather the related province_states, etc…
This works fine if the user is in edit mode or adding a new entry to the table.
The problem occurs when the user comes to the form and tries to find records for a particular country province_state and county selection.
The country combobox populates fine, but upon selection, the province_states, and county’s don’t populate.
Any one out there have a solution with maybe a small sample/code that would point me in the right direction?
thank you.