conditional value list

[cathig]

Hi, I'm brand new to Filemaker. I've created a couple of db files.

1. SchoolProj which contains printer_name, designer_name, writer_name

2. Vendors which contains Vendor_type, Vendor Name

When The user is entering info into the SchoolProj layout - I want

to restrict the Value List for printer_name to be the names of the

vendors (vendor_name) from the Vendors database - with Vendor_type = 'printer'.

Can someone step me thru this process? Does it need to be done via a script?

Thanks so much!

Cathi G.

[cjaeger]

create a global field "printer" in your main db. type "printer" (w/o quotes) into field. now set up relation printer <-> verndors.fp5::Vendor_type, then change the ValueList to use related vendors::Vendor_Name.

[Peter Fenner]

Another way would be to create a calculation (text) field in the vendors database called, for example, "printers_only" as follows:

If(vendor_type="printer", vendor_name,"")

In your school projects database you would create a value list that shows all values from the "printers_only" field. No relationship would be required.

Peter

[cathig]

thanks so much for the quick responses