Im hoping to find someone that can help me with a problem that I cant seem to resolve and it's driving me crazy!
Basically I am trying to create a child management system for a nurse using vb.net and SQL as my backend db
The application consists of a number of differen forms. Two of these forms are called "frmSearchInfo" and "frmChildDetails".
frmSearchInfo consists of:
- three textboxes "SFirstName" "SLastName" and "SDOB"
- one button "BtnSend"
frmChildDetails consists of:
-eight textboxes ID, first name, second name, DOB, phone, addressline1, addressline2, county,
The application is connected to a SQL database with two tables "Parent_Details" and "Child"
When users enter details on form "frmSearchInfo" I want it to be able to search records in the database and return the same first name, second name and DOB as well as the ID, phone, addressline1, addressline2, county. I also want the datagrid to show dates of appointments for the children.
The records needed are stored in the Child Table.
Is this possible to do or is there an easier way of going about it??
Hope that's not too confusing!
Thanks in advance!