Set the BoundColumn property to your pkey. -- rk
-----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Friday, September 02, 2011 9:57 AM To: profoxt...@leafe.com Subject: Primary Keys in SELECT Statement Forgive me if this has been asked before. I looked for it but couldn't find it. I am using an array as a row source in a list box. When I do a SELECT f1, pk FROM mytable INTO myarray ORDER by f1 the pk value is the record number from the select statement and not the pk of mytable. The control source is bound to the pk so when I put pk in the control source it points to the wrong record. I've worked around this by using another field in the table to identify the record, but it would be preferred using the pk. -- Jeff _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04419F2A66AB4@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
