Forum Discussion
Relationship between two tables
Hi Please if anyone can help me to make relationship between two tables as shown in the attached pictures , it is always give me messages as (many to many) but I need to be relationship (Many to one...
Hello assemomar ,
it shows many to many since in both tables there are many values under the functional location id, if you want it to be many to one then you should have unique ids in the one table.
Dear Mr. Idressshatila
The column functionallocationID it is the unique , please if you could help me in picture how to solve it
in the month++ table, does the functionallocationID has duplicates ?? because as per the relationship many to many it shows that it has duplicates that's why it's showing many to many.
