I

Hi Wes,

If you use scripts to control access to the fields in your portal, then you can do this.

Define a global productnumber field in your invoice database and a relation from that field to the product code field in your inventory database.

All scripts that control access to the fields in your portal should start with setting the product code from that portal line to the global product code field.

Then you can use the relation created before to display details about the product from the last clicked portal line, like

Here