Razzak, Thanks for your reply. I have just also replied to Mike's email explaining what I was doing and why.
I will have to look at the alternatives as you have suggested. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Tuesday, 12 February 2008 2:04 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB LookupListBox Error At 12:54 AM 2/11/2008, John Docherty wrote: >To answer your easy questions though, the column in question is a computed >column, (on a computed column - perhaps not the most elegant solution) and >I could change it using Data Designer to match the definition in another >table, but the form isn't trying to change it at all it just links the two >tables. John, That is the exact reason of -ERROR- message. Technically, in your scenario, using DB Lookup ListBox, when assigning "List Source Key Field" value to a Data Field (computed column "de5" in Sched), you are updating the value when clicking on the list item. Hope that explains the reason of DB Lookup ListBox Error. You may look into Variable Lookup ListBox or Variable Lookup ListView to achieve you goal. Very Best R:egards, Razzak.
