This is a small application for a PDA in Visual Basic, that connects to an SQL Server CE database with 2 tables?
The application should have a form that allows the user to select a product, by its name (prodName) from a propdown menu or a list which is populated by the prodname field in the table.
Once the user has selected the product name they should then click a button which will, on a new form display the product's description.
It will obviously get this by Finding the product the user has selected, finding it's descID, then searching the second table for that descID, and locating the corrosponding desc. It would then output this to a testbox or label.
tbl_product(prodID, prodName, descID )
(001, apple, d1)
(002, pear, d2)
(003, bananna, d3)
(004, mango, d4)
(005, pepper, d5)
(006, chilli, d6)
(d1, A green fruit)
(d2, A sweet fruit)
(d3, A yellow bendy fruit)
(d4, A red fruit)
(d5, A red vegetable)
(d6, A hot spice)
Hi, I can write this application in VB.NET, PocketPC 2003 SDK and SQL Server CE. I understand your requirements and I can do It. I can start now. Best regards,