Hello, I strive to fully grasp the concept of RDBS design while trying to teach myself the concept while designing a database to keep track on payments related to a school excursion.
I have a table with the surname, given name and address for each participant (there are more fields, but they dont matter here). The table has an ID autonumber field.
I also have a table with payment details: Date received, amount received and name of sender (as the sender is not necessarily the same as the participant). That table also has an ID autonumber field.
Each participant typically pays in installments, so that one can expect several payments for each participant, perhaps with different amounts and senders.
I try to relate those tables by dragging a join line from the ID field in each table. However, that creates a one to one relationship, which probably is wrong.
How shall I create a meaningful relationship between those tables? Which field should be related and in which "direction"?
Sorry for my poor explanation. Any suggestion is deeply appreciated.
Rgds, Bjørn Olav, Oslo, Norway.