Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7850 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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.

Posted

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

This topic is 7850 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.