topic Re: Link tables on created field in App Development

Link tables on created field

RobinB — Fri, 29 Apr 2022 13:05:30 GMT

Good day

I need some help linking my tables whilst loading.

I need my tables to link on a combination of nappi and nappi-ext, not just nappi.

Below are two tables that I need to link.

There is a field "nappi-we" that is a combination, on the table to the left. Is this correct?

How do I change my load script to achieve this link in other tables?

Thanks

vchuprina — Fri, 29 Apr 2022 13:14:57 GMT

Hi,

It's correct, but I recommend you add some symbol between fields for instance |

[p-nappi]&'|'&[p-nappi-ext] as [p-nappi-we]

[i-nappi]&'|'&[i-nappi-ext] as [p-nappi-we]

Regards,

Viltaii

vchuprina — Fri, 29 Apr 2022 13:34:19 GMT

Without a symbol between fields in the composite key, you can link the wrong data, for example