Forum Discussion

jamiefisher's avatar
jamiefisher
Icon for Helper I rankHelper I
2 years ago

Table Relationship Query

I have a draft visual to view a staff list, identify what training they are required to have based on their positon and display where that related training has taken place or not.   I can get two s...
Need Help
Data-estDog's avatar
Data-estDog
Icon for Resolver II rankResolver II
2 years ago

What fields are your relationships based on? They should alway use Primary and Foreign key. Just looking: Staff to Training table should be based on Emp No. Using a 1 to * relationship. I am guessing you used position.

 

I agree with ray_aramburo who said to delete the other relationship between TNR and staff... which is likely on based on position field.