Value list from a field in another file.

[Fossil]

If I have a database like such:

Company.........Category

a....................1

b....................1

c....................2

d....................2

I need a way to get a pop-up list, in another database, containing the Company name only for those items in category 2.

P.S. using FMP 4

[Razumovsky]

Sorry to not be so helpful, but I dont think you can do value lists based on relationships in fm4. It is easy in FM5.

[Fossil]

Well that is a little helpful. I have a demo version of FMP 6 on my home computer I will have to try it on that version. I somehow doubt we will upgrade the systems here at work though, so Im back to a double (triple, quadruple, etc.) entry system *blech*

[Fossil]

Someone from another forum pointed me in the right direction. This is how I ended up getting the correct values in my pop-up list:

Contacts file:

Company - Text field

Category - Text field using a value list using custom values.

FrghtForw Co name - Text field, using Options -> Auto-Enter -> calculated field defined as =Case(Category="Freight Forwarders", Company)

Export Orders File:

Freight Forwarder - Text field

Freight Forwarder List - Value list using Values from Field FrghtForw Co name in Contacts file.

Then used Field Format for Freight Forwarder field to choose pop-up list using value list Freight Forwarder List.

[Fossil]

Edit to the above post:

Its better to define FrghtForw Co name as a calcution field and set "Calculation Result Is" to Text. This way if I need to change information in a contacts record the FrghtForw Co name will update, otherwise I needed to delete any information in that field before changing the other info.