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