Last CVL Selection Populating Portal Merge Field

[automationaddict]

So I have a portal, and I am using a tiered group of conditional value lists to populate some the field data (This works). The problem I am having is when I get to the last drop down and make a selection, I would like that last selection to populate a merge field with data. This data is located in the same table as the last drop down. For example: The last selection is part number and based on the part number, I want to display a description of that part. Part number and part description reside in the same table but neither one of them are in the table the portal is based from.

How should I approach this?

Do I use lookup fields in the table the portal is based on?

Do I add a calculated column in the table the portal is based on?

Do I do a script to capture the last value and use that as the basis to populate a merge variable?

Can I just do this with relationships somehow?

I am really kind of stuck on this one and would appreciate any help.

[Josh Ormond]

Here is a really simple sample of just the relationship and fields/portal.

Portal Display.zip