Newbies cathig Posted May 14, 2003 Newbies Posted May 14, 2003 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 Posted May 14, 2003 Posted May 14, 2003 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 Posted May 14, 2003 Posted May 14, 2003 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
Newbies cathig Posted May 14, 2003 Author Newbies Posted May 14, 2003 thanks so much for the quick responses
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now