also jason, say i have a products table, clients table and users table.
if i want to see clients assigned to users i create a foreign key from userstbl to clientstbl.
now clients will have multiple products but be assigned to the one user, so you would again create a foreign key from clientstbl to productstbl. do i need a foreign key from userstbl to productstbl or is there no need as there is a foreign key from clientstbl to userstbl?
many thanks again