Hi, I have the follwoing situation:
- three tables a, b and c.
- Table B links records from table A to C.
- With methods I create a new record in table B, of which one of the fields is “status”
- Two statuses are available: “Active” and “Reversed”
- On my main form I have a portal showing the records from table B
- The Portal is based on a relation with on the leftside a global, the equasion is != and the right side of the relation is the status field of table B
- I have a checkbox with a method that sets the global inthe relation to “NotFiltered” or “Reversed”
- In the portal I have on each row a button with a method attached that changed the status field of the record from “Active” to “Reversed”
- If the Checkbox = 0, the records with status “Active” should be shown
Now the problem is the following:
- If Checkbox = 0 and I change the status to “Reversed” with the button in the portal, the record does not disappear from the portal
- If Checkbox = 0 and I create new records with status “Active” they don’t always show in the portal
Can anyone tell me how a portal is supposed to behave, if I have to refresh the data in the portal etc?
Paul