Jump to content

a simple portal row with two DB


pbucc

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

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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