Hi,
I appologise if this type of question has been asked previously, I have searched but nothing seems to answer my exact question, and as I'm rather new to this, never quite sure on what I acutal want/need to search on!!
I have two tables, Commitments and IncomeCommitment, both these tables have forms for data entry.
What I would like to do, is everytime a Commitment is added then a corresponding Income Commitment is created.
These tables are linked by CommitmentID field in that for every commitment there could be many Income Commitments. However to start I only want it to automaticaly populate the table with one Income Commitment.
(Note the Income Commitment table, is linked to the Commitment table with CommitmentID, the other fields are clientID which I would want to auto populate with the client from the Commitment, there is also the value field, which I have already set to a default value. Once the client has been assesed this value would change.)
Thanks.
I appologise if this type of question has been asked previously, I have searched but nothing seems to answer my exact question, and as I'm rather new to this, never quite sure on what I acutal want/need to search on!!
I have two tables, Commitments and IncomeCommitment, both these tables have forms for data entry.
What I would like to do, is everytime a Commitment is added then a corresponding Income Commitment is created.
These tables are linked by CommitmentID field in that for every commitment there could be many Income Commitments. However to start I only want it to automaticaly populate the table with one Income Commitment.
(Note the Income Commitment table, is linked to the Commitment table with CommitmentID, the other fields are clientID which I would want to auto populate with the client from the Commitment, there is also the value field, which I have already set to a default value. Once the client has been assesed this value would change.)
Thanks.
