Problem with linktable

[francisvandergr]

Can someone help me with a linktable. We have the tables: orderlines (called factuurregls) and the table Market.

In those table i have a field 'Quarter' (kwartaal in Dutch) and a field 'Range'. This are important fields. Becaus i get a loop i renamed Kwartaal to KwartaalA and KwartaalV. But i want one field calles Kwartaal.

I know this is possible, maybe with a link table ? . I enclosed a backup.

[johnw]

I don't see where you'd get a loop. It looks like you'd get a synthetic key on Range and Kwartaal?

[francisvandergr]

Thanx for your reaction, i solved the problem at the moment. Indeed it was a synthetic key