Dave Crozier wrote: > Peter, > I always load up my static lookup combo boxes using an SQL Statement into a > cursor called curX_<<combo_Name>> and bind the key (usually a primary_Key) > to the foreign key in the underlying form data. > > I used to simply put the lookup file in the DE and then use the file alias > as the Recordsource in the combobox but this produced lots of problems > (which may have been fixed from VFP7 onwards) especially the ability for the > users to update the lookup file inadvertently - which is a pain. At least > using discrete cursors the underlying data is protected. > > The only drawback is that the lookup data needs to be refreshed if the > lookup data is added to by another user, but this is a minor irritation. > Hi Dave (and others),
Did some more testing and this works great. (meaning less code). The only time I couldn't use this is when I want an extra record at the start. E.g. I have a report screen with a combo for someone to pick a value to limit the report to. I usually have the first record to be < All Data> then the rest of the table in whatever order. I usually do this by just using mycombo.additem(... Thanks to all. Peter _______________________________________________ Post Messages to: [email protected] 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/[EMAIL PROTECTED] ** 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.
