Re: Suggestion needed - VFP 7.0

On Tue, 26 Jun 2007 22:20:10 -0700, shah <shahjagat@[EMAIL PROTECTED]
> wrote:

>At this time I am using free tables and yes there will be multi users
>and I need to handle conflicts.
>
>
>I was planning to open the table in shared mode. This form is only for
>data entry of new orders so I do not have to worry about someone
>trying to access this brand new record.

*anytime* you have a multiuser app; you should worry about someone else
accessing the record.  They pull it up thru some deisgn flaw in an "order
entry"
screen....

>If I am using a SQL query as rowsource 'Select Custname, Address,
>city, zip from customers into cursor mycursor'
>
>I can show only the first column that is Custname in the combo box.
>And for pu****ng the data into field - can I use Mycursor.address,
>Mycursor.city to populate the text boxes.?

I wouldn't use sql query if you're using free tables -- just use the
fields you
want in the drop down; or add them using additem() to it.