linked adres table

[EKoster]

Hello,

My database is used for a webstore. I have a table [ data] and one [user_info].

The links:

[data.order_id] = [user_info.order_id]

Then in the [user_info] table one or more records per order. I only have one or two records per order that are of interest. One is billing adres [user_info.address_type]="BT". This is standard. If the shipping adres is different there will also be a [user_info.address_type]="ST".

In my overview on the left I display billing adres and on the right the shipping adres. If there is no "ST" then "BT" is to be used.

I have made it to the state that it collects the right info but only one is displayed. If no "ST" exists only the left is filled. If it does exist only the right is filled. Both using the correct addresses.

How I came to this point:

I made [data.cUserType_Billing] calculated field ="BT"

I made [data.cUserType_Shipping] calculated field ="ST"

I linked [data] to [user_info (alias SHIPPING)] on order_id and cUserType_Shipping

I linked [data] to [user_info (alias BILLING)] on order_id and cUserType_Billing

How can I solve my issue so both adresses are always displayed?

[EKoster]

Haven't solved this yet.

Thinking on how to create a calculated field in adres table or order table that fills with e.g. Company FROM addres WHERE order_id = order_id AND type = ST