With my joing table, is there a way to show what the id represents when you click on it, i believe ive seen something like it before. its like a hidden combo box or something? the id shows but not the name attached.
Advanced Beginner
Windows 7 
Access 2007
With my joing table, is there a way to show what the id represents when you click on it, i believe ive seen something like it before. its like a hidden combo box or something? the id shows but not the name attached.
Court Jester
Windows XP Access 2003
I don't understand the question. What do you mean by "joing table" and "what the id represents"?
Advanced Beginner
Windows 7 Access 2007
ie
Tbl1
PKthingID
thing
Tbl2
PKtbl2ID
userID
thingID
I want to know what the id number for thing stands for wihtout having to lool it up. ie thing 1 = fruit, thing 2= meat.
Court Jester
Windows XP Access 2003
You wont be able to do it by just clicking on it. You would have to run a query for it to show. That is the purpose of a relational database. Simply open up a new query in SQL view and paste in:
SELECT Tbl2.PKtbl2ID, Tbl1.thing
FROM Tbl1 INNER JOIN Tbl2 ON tbl1.PKthinkID = Tbl2.thingID
That will show you the Tbl2 ID as well as its corresponding "thing"
Posting Permissions
Reply With Quote