relationship checkbox problem.

[haret]

Hi. I'm looking for a simple solution to a problem described below:

I have a company database with a portal to employees database (related via the company ID). I have a primary contact checkbox for each employee and would like to be able to only check one employee for each company. My problem is that I can't figure out how to make a rule for the checkbox so that only one employee could be the "primary contact" for each company. (checkbox has values 0 and 1 --> false, true)

Now filemaker allows each employee to be checked so there could be 5 primary contacts. I want to avoid this. Thanks !

[Himitsu]

just put the field on the company database (table) and use a valuelist with values looked up from the field of employee ID or something like that. Now to do it the other way, from the employee database (table) it would be a little trickier. I would just go the company way, either with a pull down list on the field properties or a radio button.

[haret]

It would be easy to store the primary contact information to each individual "company"-records, but I have to keep each of the employees in a separate database due to many different reasons.

So how can I create a rule so that only one related record at a time can have the "primary" checkbox checked?

EDIT: Example

I have a CompanyA in my company database with 5 related employees (emp1, emp2...emp5). Now I want to select one of those employees to be the primary contact. Each employee record has a field called "primary". I want filemaker to allow only one checked employee at a time. So if I check the checkbox for emp3 in my portal every other employee in CompanyA should have the checkbox clear.

How can I do this?

[Himitsu]

like I said, you want to think opposite. You want put that field in the company database and not the employee. Then make a valuelist using the records from the employee field. Then for each company, you can just pull down menu, find the employee you want for that company, select him/her and it will add it to the company record. Then on the employee database (known now as a table) you can put a portal, with a relationship of employee:employee_id to company:primary and it will display on the employee database (table) which company (companies) he/she is the primary contact.

why don't you attach the file to it and we can take a look and maybe even add it to it. see if that is what you mean....

[Aileen Silver]

Hi,

Possible SOLUTIONS, Inc. has been creating custom FM solutions since 1985.

We have clients in the NYC, NJ, LI area as well as upstate NY.

If you are an Advanced FM developer who is reliable, has good communication skills, has experience with FM 6/7 and can utilize FM to the web, please contact me back channel at [email protected]

You will need access to a car to get to clients.