Table relationships question

alamfalloww

New member
Local time
Today, 21:50
Joined
Jan 8, 2014
Messages
4
Hi wonder if someone could just make something clearer for me if possible.
I have a main table called members and a table called finance each having an id key called ID_person.

I have another small table called payments which is related to the finance table using ID_payments.

I was just wondering how this works using a sub table would I need to put the ID_person into the payments table too. It doesnt like it when i try to insert into a subtable.

Hope this makes some sense. Thanks very much for any comments.
 
No you dont need to put ID_Person into the sub-table of Payments.
members has a relation to Finance, finance to Payments.

Members has a relation to payments only thru finance which is fine (can be fine)
 

Users who are viewing this thread

Back
Top Bottom