Listbox with 1 row from multiple table 1

[Xenocide]

I'm trying to create a listbox from a select that pick up information from 2 different table in the same database

As it should do.. the listbox put those 2 information in 2 row. Because of that when the user select one the other is selected at the same time but that's not what I want.

I want 1 row. I want the 2 informations to each have their own line so the use will be be able to select one or another.

Here's my select if that can help :

SELECT [Table850].[IdEngagementA], [Table807].[IdEngagementA], [Table850].[Description], [Table807].[Description]
FROM Table850, Table807
WHERE ((([Table850].[IdEngagementA])="00-000000-00"));

 

[Xenocide]

Forgot to ask if it was possible in just 1 query

 

[TheAceMan1]

How are ya Xenocide . . . . .

Have a look at [blue]Union Queries![/blue]

See Ya! . . . . . .

 

[Xenocide]

Thanks Aceman

There's still a problem.. it just show the information from the first select...

here's my new query

SELECT [Table850].[IdEngagementA], [Table850].[Description]
FROM Table850
WHERE ((([Table850].[IdEngagementA])="00-000000-00"))

UNION ALL

SELECT [Table807].[IdEngagementA], [Table807].[Description]
FROM Table807
WHERE ((([Table807].[IdEngagementA])="00-000000-00"));


This should now be moved to the Query forum

 

[TheAceMan1]

Xenocide . . . . .

Try this:

[blue]SELECT [Table850].[IdEngagementA],  [Table850].[Description]
FROM Table850
WHERE ((([Table850].[IdEngagementA])="00-000000-00"));
UNION
SELECT [Table807].[IdEngagementA], [Table807].[Description]
FROM Table807
WHERE  ((([Table807].[IdEngagementA])="00-000000-00"));[/blue]

See Ya! . . . . . .

 

[Xenocide]

Thanks for the help Aceman .. I tried mostly everything (also did that post in the query forum) and the problem come from my database but until now I can't seem to find what it is.

 

[TheAceMan1]

Xenocide . . . . .

Do the queries work individually?

See Ya! . . . . . .

 

[Xenocide]

It's ok it was a problem due to the form that was creating the entry in the table