Multi-query display dilema

[allstar45]

Hello,

I am creating a DB with a table called "References", which is joined to multiple other tables; let's call them tbl1, tbl2, tbl3, tbl4 and tbl5, tbl6.

I have 6 queries that, when ran, ask for a reference name, and output 1 field "name" with everything that is joined to that reference.

What I want, is to allow the user to look at all the things that one reference is joined to.

SO! what I did was make a form with 5 subforms, displaying the 6 queries that I made.
This is fine, exept now the user has to enter in the reference name 6 times.

Any ideas / alternate methods?

I am in school for programming, and know my way around SQL queries.

PS: I also have made a query that shows everything I want, with only 1 prompt, which looks like this:

SELECT qryRefIDtoTP1Name.name AS [cool],
qryRefIDtoTP2Name.name AS [cooler],


qryRefIDtoTP3Name.name AS [coolest],
qryRefIDtoTP4Name.name AS [massive cool],
qryRefIDtoTP5.question AS [Question cool],
qryRefIDtoTP6Name.name AS [cooling point]
FROM qryRefIDtoTP1Name, qryRefIDtoTP2Name, qryRefIDtoTP3Name, qryRefIDtoTP4Name, qryRefIDtoTP5, qryRefIDtoTP6Name;

but the results are every combination of all of the rows in each query result.

[pbaldy]

When you have no joins between the source tables/queries, you get a Cartesian product.

[allstar45]

Thanks for the reply,

I have nothing to join the query results ON. Is it possible to join them without a foreign or primary key? All the tutorials have had a primary key and a foreign key.

[pbaldy]

Not really. Is a UNION query appropriate to your needs?

To your first question, which I didn't notice, the way to avoid multiple parameter prompts is to have the user enter the criteria in a form, and have the queries get it from there.

[allstar45]

have the user enter the criteria in a form, and have the queries get it from there.

That definatly sounds like it would work. I will have to try to find a tutorial of that. Is there any you reccomend?

I tryed a UNION, which worked, but all the results get pushed into one field, which is definatly not prefered.

[pbaldy]

It's pretty simple. Instead of this in a query criteria

[Enter whatever]

you have

Forms!FormName.ControlName

replacing the form and control names to the actual names.

[allstar45]

OK I'll try that tomorrow and let you know how it goes!
Thanks again!

[pbaldy]

No problem, and welcome to the site!

[allstar45]

Works like a charm! Happy Valentine's day!