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)

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

Create an join file Company_PageSz with following structure:

company

page_size

For each company add as many records for sizes it use.

Now, in your main file define list "companies" use values from field company in file Company_PageSz.

than create an relationship from your file to Company_PageSz file usinggcompany field in both file.

And at last define list PageSize use related values(from above relationship) from field page_size in file Company_PageSz.

That's all

Dj

Also answered in linked pop up lists .

Chris, please don't cross-post your questions anymore.