i found many posts and discussions about how to create linktables / keytables in QV. I am not very good in english, perhaps that is the reason why i d not understand how to create a linktable. Here ist my structure:
Kundenstamm: LOAD st1_knr , st1_knr AS s_kundennr , st1_nam ; SQL SELECT * FROM cdix.fyrst1;
Auftragskopf: LOAD kop_aufnr , kop_kunde , kop_kunde AS s_kundennr , kop_anl_datu , kop_anl_datu AS s_datum ; SQL SELECT * FROM cdix.fakop;
Rechnungskopf: LOAD tfk_beleg , tfk_kunde , tfk_rechdat , tfk_rechdat AS s_datum , tfk_kunde AS s_kundennr ; SQL SELECT * FROM cdix.fatfk;
