Hello all,

Recently I downloaded a version of Filemaker Pro 11 and now after a few days of playing around and looking for answers and solutions I am stuck.

I created three tables, first a companies table (only company names), second a user table (only user information with a valuelist showing company names in a drop down). Third table is a projects table where the company name is a valuelist showing the company names in a drop down). The last field is where I want to select a user with a dropdown, however I only want to show users in the dropdown that relate to the 'already' selected 'company name'.

* note, tables as described are simplified to the fields of my concerns.

companies

- id_company

- s_company_name

users

- id_user

- s_username

- s_company_name << valuelist from companies >>

projects

- id_projects

- s_company_name << valuelist from companies >>

- s_username * (valuelist)

* where i want my userlist that is filtered by company

I have been playing around with calculations etc. but i can't get it to work. Any help is welcome.

Regards,

Peter

First, your Users table should contain a CompanyID - not company name. Similarly, the Projects table needs to have CompanyID and UserID. Otherwise you won't be able to rename an object without breaking your relationships.

Now, assuming you have the following relationships in place:

Users >- Companies -< Projects

define a new value list and set it to use values from Users::UserID (also show Users::UserName), include only related values starting from: [Companies].