How To link 2 Tables with one unique Key to avoid synthetic key

[Nawfal-Franke]

Hi guys,

I have a problem with my model.

I want to link two table "expéditions ventes" with "SalesInvoiceLine" with a unique key to avoid synthetic Key in my model, I want to concatenate ("Key Table with Order No") and use  AutoNumber but I don't know how to do it .

Here is the details of my 2 tables :

ExpéditionsVente:

SalesInvoiceLine:

 Thank you guys for your help.

Kind Regards

[Nawfal-Franke]

Hi guys,

Any help please I really need it to complete my application.
Thanks.

Kind regards

[Brett_Bleess]

The following Design Blog post should take care of helping you get things sorted:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett