Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Can you please share an example with me.
Thanks
start With this.