Combining multiple data into a single text box

[ITbeast]

Hello,

I have a table called house_table that references lname_table and fname_table. So a house may have 1 last name assoicated with it or 2 or 3 or whatever. What I want to do is have a form that shows all information for a house shown in multiple text boxes, then have all names assoicated with that house compiled into a list box or text box. I am trying to populate the list box using a query but I can't get the results I want. Any suggestions?

 

[traingamer]

There are ways to do that, but why not just use a subform?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Zion7]

Like Greg said, a subform. Or maybe a query behind a
listbox with a parameter from the main form?

BUT, your problem seems to be the query itself.
I'm assuming your main table is normalized.
So all last names associated with a house, are on a different table?

Why am I feeling, this is not the case?

We should see your SQl for the query attempts.

 

[TheAceMan1]

How are ya ITbeast . . .

I can't help but agree with [blue]Zion7![/blue] . . . [purple]whats the point of first/last names in seperate tables?[/purple] . . . [blue]it doesn't appear the tables are logically normalized![/blue]

See Ya! . . . . . .

 

[Zion7]

Thank you Aceman!
...actually, you also just clarified something for me.
So those are 2 separate tables, each for first & Last names respectively.

Is it safe to assume that you've defined a key relationship?
between all tables?
If so, that join should automatically be created when creating a query. This should group your related data.

All that is left to do, is if using subform,
define Master & child links,
or if using listbox,
set parameter as main form Primary key, and requery using
OnCurrent event.

Capeesh?