Beginner Help?

[Mark_SC.SE]

How do you display relational information between 2 tables using ASP?

I have 2 tables, one table with 1 column with peoples names and another column with an ID number set to their name, the column has been named "CarID".

And a second table with a column of cars and a column of ID numbers also called "CarID".

Ive created a relationship between the tables via the "CarID" column, but dont know how to display the information.

I know how to display recordset data using ASP of SQL Statements. But am trying to figure out the point of relational databases if there isnt a simple way of displaying the information.

example:

table 1 has a record with the columns "Name" and "CarID"

Katie, 1

and table 2 has the columns

"CarID" and "CarType"

1, Porsche

So if I want to display the information on "Katie" (including what car she drives) how would i do this?

Any reply would be appreciated!

Hope this post makes sense

 

[KingKong]

relationships are the key

I hope this is what you're looking for?

check the db_example (attachment)

 

[Mark_SC.SE]

aha!

thankyou, yes thats what i was trying to do! ta