for example my fileds legal Entity, ordernumber and year:
Orders:
load
"legal Entity" & odernumber & year as link,
"legal Entity",
ordernumber,
year,
other fields
from orders;
invoice:
load
"legal Entity" & odernumber & year as link,
invoivenumber,
other fields
from invoices;
so you have a link field between the tables with all relevantes fields that the links is unique
and you have separate fields for legal Entity, ordernumber and year to select.
it is better to load the separate fields in those table where are all datas in. you can have a ordernumber without an invoice, but you can't have an invoice without an ordernumber, so it is logically that you use oder table for those fields.
