Hello,
I have a database with the relationships as follow;

Uploaded with ImageShack.us
The annual reducing balance table automatically populates the Person_ID, however I also want it to populate the support_plan_id which links it back to the support plan.
As there could be multiple support plans with multiple annual reducing balances for each.
Hope the above makes sense in a roundabout way if not let me know.
Ta,
Junk
I have a database with the relationships as follow;

Uploaded with ImageShack.us
The annual reducing balance table automatically populates the Person_ID, however I also want it to populate the support_plan_id which links it back to the support plan.
As there could be multiple support plans with multiple annual reducing balances for each.
Hope the above makes sense in a roundabout way if not let me know.
Ta,
Junk