G
Guest
I already have a relational database between two tables (table A and table B)
and am trying to create a relationship between table B and C. Table A has
all client details (ID key, name, address, phone, birthdays, etc.) and Table
B has loan details (ID, ID key from table A, loan amount, lender, loan
number, settlement date, date commission received, etc.). What I would like
to set up is for Table C to have a list of the commission received each month
for each loan number (one - "B" to many - "C" ??). At the moment I have the
commission info in a spreadsheet. I am doing something wrong as it wont work.
and am trying to create a relationship between table B and C. Table A has
all client details (ID key, name, address, phone, birthdays, etc.) and Table
B has loan details (ID, ID key from table A, loan amount, lender, loan
number, settlement date, date commission received, etc.). What I would like
to set up is for Table C to have a list of the commission received each month
for each loan number (one - "B" to many - "C" ??). At the moment I have the
commission info in a spreadsheet. I am doing something wrong as it wont work.