brandx
Posts: 29
|
| Posted: 10/02/2004, 10:06 AM |
|
ASP/Access
CodeCharge Sudio
Hello everyone, I keep running into this same problem and haven't been able to solve it yet. I've seen other posts in the forum that are related to it "query builder" but haven't got any of them to work.
I have a table.... "person" with fields... fname, lname and positionID... The positionID field is an "integer/autonumber" ID that links to another table "position" with all the different positions in it.... on the record side.. i don't have any problems linking a list box to this table and showing the actual position instead of the ID... but everytime a make a grid... only the PositionID is shown... i've tried using query buider... but cannot get the actual position to be displayed... only it's ID.....
So.. cheesily..i've solved this problem by making the actual position the Primary Key.... and getting rid of the integer ID all together.. i know this is not right.... can anyone point me or give me detailed instructions on how i can get this to work properly?
Cheers,
Geary
|
 |
 |
peterr
Posts: 5971
|
| Posted: 10/04/2004, 12:40 AM |
|
Hi,
You may need to change the "ID" to "position" in the "Control Source" property of your label in the grid. This can be done after you select both tables and join them in VQB (in Grid's datasource property).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Geary
|
| Posted: 10/04/2004, 4:54 AM |
|
Thank you peterr
now that you've given me the answer... i feel kinda foolish.... do you have a dumbest question of the month at yes software?
Thanks again 
Geary
|
|
|
|
|
