SQL to show records from 2 tables in single listbox

[JenniferM]

Hey guys,
I'm sure there's something really simple I'm overlooking here, so I'm hoping someone more learned will be able to point me in the right direction.

Here's what I've got:
When a patient fills out an initial visit form (which corresponds with TblInitialForm, primary key is ID), their surgial and non-surgical plans are recorded in two separate tables, TblSurgPlan and TblNonSurgPlan. The primary key for both tables are ID (which is linked to the initial form ID, and ListID, which is 1,2,3, etc. based on the order in which they were added.) The plans are recorded as text in SurgPlanString and NonSurgPlanString. Right now, both tables are shown in 2 separate listboxes... This looks really awkward though, so I was wondering about the steps I would take in the rowsource of the listbox if I wanted to display both tables in the same one.

This is the current SQL I have in one of my listboxes:

SELECT TblInitialNonSurgPlan.NonSurgPlanString
FROM TblInitialNonSurgPlan
WHERE (((TblInitialNonSurgPlan.ID)=[Forms]![FrmInitialForm].[ID]))
ORDER BY TblInitialNonSurgPlan.ListID;

Right now the bound column is set to ListID, but if I were to combine them, I could switch the bound column to the text field, because that would not be the same in either table.

Any advice on how to approach this in SQL? I'm stumped and don't know where to start!

Thanks!!

[Rabbit]

Use an inner join to join both tables. To display both fields in the listbox, you would just need to concatenate the two fields together, probably with some sort of delimiter.