Re: Joining existing records in two tables

I'm afraid my VB skills aren't up to par for that yet.


"TC" <aatcbbtccctc@xxxxxxxxx> wrote in message
news:1143595279.413340.41000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I imagine you'll need to write some code to change the PKs in table C
to match the records in table B.

If you had to let the user do this manually, I'd do something like
this. Have two listboxes, one on table B, and one on table C. Let the
user click a record in each box. Then, when he clicks a command button,
code behind the button would see what record he had selected for B -
extract the relevant PK for C - then write that PK into the record he
had selected for C.

Would that work?

HTH,
TC (MVP Access)
http://tc2.atspace.com



.