linking subforms

B

bfence

Hi! I know there's a way to do what I need, but for the life of me, I
can't get it to work.

In my database I have tables for Teacher Candidates (TC_Char),
Candidacy (Cand) , Entitlements to name the relevant ones.

TC_Char
UIN - pk

Cand
CandID - pk
UIN

Entitlements
ID - pk
CandID

I've got the forms for each set up in tabs off the main (TC_Char)
form. UIN is linked from parent TC_Char to Child Cand. Now what I
need is for CandID to be linked between Cand and Entitlements. The
subform for Cand is set up as continuous and it needs to stay that way
since any teacher candidate can be in more than one of our programs.

How can I get CandID linked between the two subforms?

Thanks!
Betsy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top