hi there,

i know this is a simple question.

i have 2 db. one is called "work order" and the other is called "materials"

materials just has a list of material names and prices.

the work order db will create new records and i want to be able to use a pop up list or portal to show the list of materials that are in the "materials" file. i have made a few other relationships to other files and they work great. this one is bugging me cause i know it's an easy answer.

thanks

peter

Create a calculation called "constant" in each db is defined as 1 (the calculation simply returns the value of "1". Create a relationship in the Work Order db to the Materials db that links the constant field in each db (constant::constant). For your pop-up field, define a value list and choose the "related file" option to select the constant::constant relationship to the Materials db.

The "constant" field trick is also a neat way to create a hot "index" sidebar on a layout, which is handy if it has a manageable number of records: create a portal for (constant::constant), and make each portal row serve as a button to go to the related record...