Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Compiling several results into 1 field of a query.
Tue, Oct 2 2007 11:01 PMPermanent Link

Phil Read
Hi Tim,

I wondering if it's possible to easily do this....

Here's 2 basic tables storing rooms and owners.

[ROOMS]
roomNo    ownerID
----------------------
A1             1
B1             2
C1             1


[OWNERS]
ownerID    name
-------------------------
1              Joe Bloggs
2              Bob Smith


What I want to do is list the owners in a drop down but also show the
rooms they own like this:

1 Joe Bloggs (A1,C1)
2 Bob Smith (B1)

So I was thinking of a little query that will return 3 fields, the
ownerID, name and rooms which would contain all related rooms in 1
field, almost like an array although access to the individual rooms in
this field is not required it's purely to display in the drop down so
the user can visually associate the rooms with a particular owner.

Is this easy to do?

Thanks,

Phil
Tue, Oct 2 2007 11:01 PMPermanent Link

Phil Read
Apologies, this should have been posted in the SQL group.
Wed, Oct 3 2007 9:22 PMPermanent Link

This message was cancelled from within Mozilla.
Wed, Oct 3 2007 9:22 PMPermanent Link

This message was cancelled from within Mozilla.
Image