View Full Version : recordset problem

06-28-2007, 08:35 AM
Hi to all! I'm sort of a newbie in databases so I'm facing this problem.
I got these tables in access database :
tblNames ---------------------------- tblDebts
namesID ----------------------------- debtsID
name ---------------------------------- namesID
surname------------------------------- amount

So, the namesID and namesID are related one to many relation.
What I want to do is in my debts dynamic table in dreamweaver to show the debts but instead of the numeric values of namesID column to show actual name and surname from names table. I know this has some stupid and easy solution but you know me the newbie lost in SQL :)
Please anyone can help? It's urgent!!
Thanks in advance !

06-28-2007, 12:30 PM
look up relationships in access

there is a visual tool on the tool bar where you can drag a field reference from one table to another to create join query