I have a drop down list that will show only record based on a relationship.
Table 1: Labor
Table 2: Staff
Table 3: Activities
Staff go to labor
Add a record
Enter their name and dept
Drop down list shows that dept's activities
It works but only once!
If you enter a dept your get the right activities
If you then change the dept the activities option do not change.
I tried adding a commit and a refresh.