Table relationships question

[alamfalloww]

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.

 

[namliam]

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)

 

[alamfalloww]

Magic thanks again