I have an HOA Association membership application.
One thing I am tracking is who is at a specified meeting.
Here are the relationships:
When I delete a Member, it also deletes his PK. This results in the PopUp Menu showing
This makes sense except for the fact that his PK *IS* showing???
Why does FM store the PK, -- 145 (I know, which is what is actually stored) but not the 2nd field 'cNavName'?
I seems like my choices are: Use a lookup or set values from the first field to: CNavName
Or, is there another way?