Allow user to select company from drop down list

[natemclain]

I have two tables Company & Parts.

I have a one to many relationship from company::companyID -----< parts:companyID

I want the user to be able to select a company from a drop down when they use the Filemaker New Record button from the toolbar.

I can only see the current value list I have created if I have the customerID filled in manually, otherwise the drop down doesn't display any of the companies so the user can make a selection.

 

Any help would be great.

 

TIA,

 

Nate

[IT_User]

Hello Nate,

Is the value list created by a table?

If it is based on a table does the value list setting have "Include all values" or "Include only related values starting from"

Change it to "Include all values"

 

If the value list needs to start from another table, you might need to create another TO for that (excluding the CustomerID).

 

btw, is the companies related to the customer, or is it a company for the parts (or something else)?

 

-------------

If it's from another file, you might need to create a new TO, as well.

-------------

Manually entered and created value list should show up.

 

HTH

[natemclain]

IT_User,

 

Thanks for the reply.

I had the field set wrong on the Parts Layout. I setup the Company drop down field using the Customer:CustomerID instead of Parts:CustomerID. As soon as I changed that the drop down populated correctly when I created a new test record.

All your suggestions were spot on when I checked them. Luckily it was just my inexperience.

I guess that's how we learn. :-)

 

Thanks again!

 

Nate