how do i join records from two tables via a form

[Kananelo]

Folks, i need help with a working code that would perhaps go into the after_update of my form.

I have a form that is based on one table "tblReferral" then the rest of the fields are combo boxes that look up data in two unrelated tables.

What i need to do is:

Pupulate these combo boxes with data from these unrelated tables save them as a new record.



E.g tblPatients has patients, tblGuardians has guardians of the patients, i would then select the name of the patient and the guardian and click save. Patient records now indicate "Michelle Blake" as the patient's guardian.

[jgelpi16]

Let's start with a dlookup() method. Would that work? have the dlookup() result dumped into the corresponding tables which are bound to your fields. Is that on the right path for what you are looking for?

[Kananelo]

let me try and use that... i'l keep you posted in case i need clarity.