Hi.
I created a database using access to my site.
I got 3 tables with relationships. tbl_Bets got field called "League", integer, linked to the field LID in the table tbl_Leagues. the tbl_Leagues have another fields, one of them called "LeagueName".
My question is like that:
I created a loop to show all bets using asp (NOT .NET) , and I want to show the field "LeagueName",
But my object RS is opened on tbl_Bets (requiered to the loop). I dont want to show the ID.
Do I have to create a new recordset object and open SQL seeking for the right ID everytime or there is a solution using the Relationships or something?
...
Go to the complete details ...