Problem regarding join

[#1]

Hi all. I have a problem regarding shipping address and billing address in a table. The problem is: Table1: ShippingAddressID BillingAddressID Table2 AddressID How can i do that in the interface i have only AddressID that is mapped to both fields in Table1 ?

[boorgura]

You will have to replicate the field in Table 2.

AddressID as BillingAddressID,
AddressID as ShippingAddressID

[#3]

Hi and thank you for your reply.

I have allready did that but the problem is that it creates a syntetic key.

[boorgura]

you can create a key using both the fields.

(may be by just concatenating them)

and then rename the individual fields differently in the 2 tables.

if all you want to do is get the syn key out.

But I believe the syn key should be doing the same thing for us implicitly.

[#5]

Hi.

BillingAddress and ShippingAddress are not allways the same. I cant see how i can create a concatenated key from those fields because sometime

BillingAddress & ShippingAddress <> AddressID & AddressID.

[#6 · Accepted solution]

Hello Christian,

if I got you right, you have in one table two times an address_id pointing to one (address-) table. I would load the address-table twice with different table names and qualified fieldnames(!) using code similar to:

BillingAddress: load . . . AddressID AS BillingAddressID; . . . City AS BillingCity; . . .

ShippingAddress: load . . . AddressID AS ShippingAddressID; . . . City AS ShippingCity;

Regards, Roland

[#7]

Hi Roland.

Thank you for the solution. This solution removes the synthetic key.

Regards,

Cristian.

[kaushalview]

Hi,
Use this

AddressID AS BillingAddressID

AddressID AS ShippingAddressID