related field within a portal

[djbrewer]

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!

[BobWeaver]

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.