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

linked pop up list


chris_brown

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

Recommended Posts

Hi, I have created a database in FMP and I have 2 pop up menus one is comany name and the other is the size of paper eg:a1,a2,a3,a4,a5 but the sizes are all different to each company. So the question is, is there a way of selecting a company name and it bringing up all the sizes that relate to that company that I have selected in the comany pop up menu box. (I dont know much about relationships) I have created another database with two menu fields, company and Size and have created the 3 companys (company 1, 2 and 3) and in the other field, sizes 1 - 14. I then created 14 records. matching comapany 1 to sizes 1-6 company 2 to sizes 7-10 and company 3 to sizes 11-14.

I really need a straight forward way of understanding how to do this as I am very new to File Maker Pro.

For example

I choose Adidas as the comany

the second pop up menu brings up all products that relate to Adidas

On the next record I choose Nike

the second pop up menu brings up all products that relate to Nike

Thanks for any help

Chris

Link to comment
Share on other sites

Let's call your first file Companies and your related file Sizes.

The following steps are all done in the Companies file:

1. Define a value list call company. Click the "use values from field" option. Then click the Specify File option, and choose Sizes, then choose the company field.

2. It sounds like you know how to set up pop-up menus, so assign the company value list from step 1 to your company field.

3. Define a relationship to the Sizes file based on the company field.

4. Define a value list called sizes. Click the "use values from field" option as before, but this time, click "only related values," then choose the sizes relation from step 3 and choose the ::sizes field.

5. Assign the value list from step 4 to your sizes field.

And there you have it!

Link to comment
Share on other sites

This topic is 8189 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.