Multiple retrievals

Calisonic · May 5th, 2005, 06:19 AM

Greetings.

The problem I have is that I need to get two sets of data from tables in an access db, and display them in one object.

When I click this button (you'll have to imaging the button), I need to retrieve:

Code:

[UserName], [Location], [Status], and [LastActivityTime], for each user, where [Online = 'Yes'].

I can get all of the data I need individually, but I need to populate a datagrid with all the required information, and in a single click.

Here's the idea:
The form goes to the top row of the table.
If the user (let's call him Alf) is online, the top row of the datagrid is changed accordingly:

Code:

Username   Location       Status      Last Active
-------------------------------------------------
Alf        Comedy_Room    Member      9:36 PM

If Alf isn't online, it just ignores the entry, and moves to the next one (.MoveNext). Either way, for the next user online, lets' call her 'Nancy', the grid will look like this:

Code:

Username   Location       Status      Last Active
-------------------------------------------------
Alf        Comedy_Room    Member      9:36 PM
Nancy      The_Lockup     Moderator   9:42 PM

How is it possible to retrieve data from one table (UserName WHERE Online = 'Yes') and then from another (Location WHERE UserName = Alf)
(Alf being the name of the user currently in question)?

Thanks for any help or tips.
This isn't urgent, as the trial version of the program doesn't have this function, anyway.

That said, I'd like to get cracking with it, so if you can help me, I'll be your best friend.

Tom

D-Cal,
HRIC, Calisonic.

gbianchi · May 5th, 2005, 08:47 AM

hi there..

dont seeing the structure of your tables dificult the answer, but basically you need to do a join between the table that has the user status and the table where you have the location..
access can do it for you.. .or any other database can construct the query for you...

HTH

Gonzalo

BrianWren · May 5th, 2005, 01:38 PM

Code:

SELECT UserName, Location, Status, LastActivityTime
FROM   <put tablename here>
WHERE  Online   = 'Yes'   OR
        UserName = 'Alf'
ORDER BY Online, UserName;

Calisonic · May 13th, 2005, 10:23 AM

Thanks a lot, guys.
I'll try that out when I get back.

If it works, my app will be ready for launch, so it's critical now.

Thanks again.

D-Cal

D-Cal,
HRIC, Calisonic.