Hi Folks:

I am designing a contact database in FMP8.5 and I have created a self- relationship between CONTACT A and CONTACT B. I have a conditional value list for the contact names that is based on their department. When I go from one department to the next the contact name that was in the previous department falls under the department that I just moved to.

What is happening is that the department name for that contact is changed to the department that I went to. In the relationship set up box creating new records is not on for either CONTACT A or B. The value list for departments is based on CONTACT A and the one for contact name is based on CONTACT B.

Can anyone tell why the department name would be changed simply by selecting another department o view?

TIA,
Peter

Reply via email to