Jump to content
Sign in to follow this  
djbrewer

related field within a portal

Recommended Posts

i have a invoice dbase, an product dbase and product detail dbase.

the reason for having the prodcut detail is that a number of the different products have the same details (sheet music, guitar chords, audio file all of the same song).

i want to be able to see the product detail in the invoice dbase, but it seems as though you can only view one level and i want to put a related related field in a portal. help!

Share this post


Link to post
Share on other sites

You will have to set up a product detail field in your product database as an autoenter-lookup from the product detail database. Then, this information will be available to the portal in the invoice database.

Another option is to use a button and script to copy the product ID out of the selected portal row, and into another field in the invoice record. Then, have a relationship directly from the invoice file to the product detail file. But, you would only be able to display one product detail at a time.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.