Access relationships

Associate
Joined
21 May 2006
Posts
327
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
 
Back
Top Bottom