Yet another vb question-Relationships

[crazymotorbik...]

Hey,

I'm currently trying to get back into vb6 but I'm having a few problems remembering how to do stuff!

Today's question is:

I am trying to remember how vb handles relationships.

For example if I search an entity that has a relationship with another entity (Set-up in MS Access) how do i retrieve the data from this other entity through the relationship.

I have searched on Google but the only results i can find are for creating the relationships.

Cheers,
Shaun.

[Alexio]

I think this depends on how you are connecting to the database. As far as I can remember you could either use DAO or ADO (I think? It was ages ago).

I seem to remember my code selecting a database table and only being able to navigate forwards and backwards through the returned data set. I don't remember any relational provisions at all.

Is SQL involved? Are you using OBDC? If so it's likely to happen in exactly the same way every other language on the planet handles it. If not, I don't know how to help.
____________________
will never give up his CG. I look at my fuel gauge more as a progress bar than a fuel gauge.
G: With my GSXR I do often effectively use it as a scooter with a clutch in town.
ms51ves3: why does it need 500 miles? Are you teaching it how to be a piston?

[Frost]

Don't think i really understand the question. Perhaps your talking about SQL rather than VB? in which case said relationships are most likely a JOIN statement.

People_table
User_id Name Age
1 Bob 25
2 James 55

Job_table
User_id Job
1 milkman
2 pilot


SELECT Job FROM job_table JOIN People_table using (User_id) WHERE Name="Bob";

so you state which tables you wish to use, and what field you want to connect the 2 using.