>>>>
>>>>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