ok I have a table name DOCUMENTS and in this table there is a few attribute to the table but some of them change depending on what MARKET wants them so I have the table DOCUMENTS---DOCUMENTS_MARKET--MARKET
(many to many relatioships) now in my DOCUMENTS_MARKET I have the 2 primary keys from this 2 other table it works but then when it comes to joining DOCUMENTS_MARKET to some other tables of the database Im not sure how to do it because there is 2 primary keys thanks aloottt
The simplest way of achieving that would consist in adding a surrogate primary key (Autonumber) to the table DOCUMENTS_MARKET and using it to create links with other tables. Otherwise, you'll have to work with a composite key made of the two foreing keys already stored in that table.
Oh really thanks ! Thats true.. for some reasons i thought when you had a many to many relationship.. the table in the middle needed to have the 2 primary keys from the other tables as primary keys... But yes you must be right it makes sense
but i dont think it fix my problem umm..
DOCUMENT A can be buy by MARKET A
DOCUMENT A can be buy by MARkET B
DOCUMENT B can be buy by MARkET A
then the document A bought by market A is different than the document A bought by maket b.. it depends on the Market rules.
and then i have to join this "new " documents to other tables
so if i set the index as no duplicate its not gonna work.
it gets complicated ive been working on this for a while now