Display records from multiple tables in single portal.

[lanceomni]

I have a portal which displays data from [use] table with fields "propertyID" "Line#" "Code" "Size" sorted by Line number.

Line# Code Size

01 5000 400

02 8000 100

03 3000 85

04 8000 250

In a second table [uSECODES] I have fields "Code" and "Description".

Code Description

3000 descr a

4000 descr b

5000 descr c

6000 descr d

7000 descr e

8000 descr f

... ...

I want to display the description of the code in the above mentioned portal so it would be something like this

Line# Code Description Size

01 5000 Descr c 400

02 8000 Descr f 100

03 3000 Descr a 85

04 8000 Descr f 250

Currently the relationship goes as follows

[PROPERTY::ID] ----< [uSE::PropertyID][uSE::Code] >---< [uSECODE::Code]

[mr_vodka]

All you need to do is put the related field in the portal.

[lanceomni]

And it will align with the correct code? Well that was easy.

Thank You