Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Compiling several results into 1 field of a query. |
Tue, Oct 2 2007 11:01 PM | Permanent 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 PM | Permanent Link |
Phil Read | Apologies, this should have been posted in the SQL group.
|
Wed, Oct 3 2007 9:22 PM | Permanent Link |
This message was cancelled from within Mozilla.
| |
Wed, Oct 3 2007 9:22 PM | Permanent Link |
This message was cancelled from within Mozilla.
|
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |