So what I am trying to do is to figure out between two tables which one has the bigger Record ID. Once I find that out I want to output this number with a +1 to a text box.
So the above code gets me what I need, however I am not sure how to put an if statement that if one is greater than the other to output the number +1 to me.record_id.text
Code:
Dim DataConnect As New Data_Connection_Final
Dim Staff As String = ""
Dim DataPullStaff As New DataSet
Staff = "Select MAX([Record ID]) from Staff_Position"
DataPullStaff = DataConnect.GetDataSet(Staff)
Dim TBH As String = ""
Dim DataPullTBH As New DataSet
TBH = "Select MAX([Record ID]) from TBH_Position"
DataPullTBH = DataConnect.GetDataSet(TBH)
So the above code gets me what I need, however I am not sure how to put an if statement that if one is greater than the other to output the number +1 to me.record_id.text