>>>>ok can i like use the same method to scroll thru a different table using a combo box?
>>>>
>>>>
>>>>cause im implementing into my real program now. but the SQL populates the combo box from Table X and the fields get their values from Table Y. i need Table X like this because i wanna be able to add stufff from X to Y Y doesnt hav all the fields.Since it isnt always needed.
>>>>
>>>>so can i populate from X and still be used 2 scroll y?private keyS?
>>>
>>>Sorry but I don't understand what you are saying.
>>>Cetin
>>
>>ah ok like if we do this
>>

>>select * from table1 where item='E' into cursor crev&& combo box source
>>&&inter change 
>>=seek(crev.id,'crev','id')
>>thisform.refresh
>>

>>this works fine if the control course of the fields is going to be table1.X
>>
>>but what if i want the control source to be table2.
>>so like if we select PEter from table 1 we get to see its number which is 5 that exist in table 2
>>if we select Kem from table 1 we get to see my number which is 1. thats possible?
>
>I think you're going in cricles. The combobox rowsource should be one cursor, and your form controls should be bound to a different table (cursor).
>
>=seek(crev.id,'crev','id') -- makes no sense - why do we need to search in the same table?

ahhh i think im 2 tired

=seek(crev.private,'test','private')

its like i want to use THAT code to scroll ANOTHER table
table1.number=table2.number?