Issue in data model

[sannidhikumar]

Hi All,

PFA.

We have created 2 tables key is comman in 2 tables.(Key is composite key bu using resp fields in table).

But for some fields like

00610|LC|001410|2060

00620|LC|001410|2060

00670|LC|001410|2060

associated values are not showing though values are present in backend db.

Can you please suggest on this.

Thanks

[sannidhikumar]

Hi Staffman,

You mean I need to use single key value rather than forming composite key.Moreover we tried to concatenate the two tables but it does not work.

Thanks

[stabben23]

No, use compisite keys if you associate the data model, use Your Field key as you do in Your join, but without join part.

When you concatenate it will use all common keys when it concatenate. You can here remove the composite keys and instead use the Fields that is common. You shold also rename the Fields when concatenate so they have the same name in both tables. ex ARV_CO as CO, AR_CO as CO. But if Your not familliar With concatenate use Association.

[sannidhikumar]

Can you please share an example with me.

Thanks

[stabben23]

start With this.