C# relational dataset

[budjo]

Hi, i have two tables .. they are supposed to be related by a Columnid = ContractorID here's the structure:

Gloves Contractor
GloveID ContractorID
ContractorID ContractorName
GloveDesc

*using MYSQL

-- Im using windows form, i can easily add new records , with a textbox and a combobox for Glovedesc and ContractorName resp. , GloveID is autoincrement


I have a navigate button , last,next,prev,first on the form, my problem is how to sync the Gloves Record with the Contractor Record, i tried add DataRelation on the Dataset, but when i click the nav buttons, only the Gloves Table is navigated, Contractor Table remains at position 0

im using one Dataset for the two tables ...

my work around was to get the current value of contractorid from the current record in the Gloves Table and do a .rowfind() on the Contractor Table, I can find the datarow but , dont know how to get the position of the datarow found and used it to change the current position of the Contractor Table , any suggestion?? plss .. tnx in advance ..

 

[JCruz063]

budjo,
How does your navigation code look?

JC

Friends are angels who lift us to our feet when our wings have trouble remembering how to fly...