hello everyone,

I am having trouble with making a simple overview to see who works at what company and making new companies or Employers

if i wanna show the people working in company x, filemaker always wanna change my records. Instead of just showing, filemaker changes it or making a new record. But it can't be done since i want the companies to be uniek in name.

Does anyone have a simple example for this.

Just 2 tables

company

employers

relationship is in one company can work more employers.

i wanna look in my companies layout what people work there

and if i make a new employer i wanna chose from existing companies where he works, without making a new company just chose.

thx for ur replys and/or exapmles

see attached

Co_Emp_Rel.fp7.zip

thx for helping this n00b out :