>>>>>>
>>>>>>ok so is ID like the number of the table?
>>>>>
>>>>>Sorry, I haven't looked at the whole thread. My assumption is that Naomi expects the table to look like this:
CREATE TABLE Test (ID int, Name C(20))
>>>>>INSERT INTO Test (Id,Name) VALUES(1,"Tom")
>>>>>INSERT INTO Test (Id,Name) VALUES (2,"Dick")
>>>>>INSERT INTO Test (Id,Name) VALUES (3,"Harry")
>>>>
>>>>well no i have a view that gets 3 names and i show them when i load the form.
>>>>
>>>>what you said previously looks cool i get it
>>>>i have and ID problem is i cant used it like that cause it differs
>>>
>>>OK - show use *your* data and maybe we can tell you how to extract what you need.
>>
>>well its gone be hard.
>>I used a View
>>V_clients
>>
>>number name type
>>1 jerry 3
>>2 peter 2
>>3 pan 8
>>
&& views dont look like that but i cant show pictures
>>
>>now i can set the control source of the text boxes
>>but if i do v_clients.name thats only going to get jerry in the first text box i need peter and pan in box 2 and 3
>
>Is 'number' an actual field in your view? If so just use 'number' instead of 'Id' in the Select statement
well number is not 1,2,3
but now that u mention it you think i should add it?