I have just finsihed creating an access database that analyzes sales data and finds commissions and whatnot. I am trying to now use VB.Net to finish the second part of the project. What I want to do is have the user type in the invoice number into a textbox and click a command button, this will return the line detail from the invoice as well as the broker, invoice total, customer, etc. Each invoive have a different number of line items so I am not sure if or how to set it up so that it would display the records in labels and textboxes. I not sure how to display multiple records in VB, let alone a varying amount of records. I have only used VB adodc in VB 6.0 and to display one record at a time.
Is there any way that I can do this. Any way that I can display the results of the query in the form. I am pretty new to VB.Net so any suggestions on where to start would be greatly appreciated.
Is there any way that I can do this. Any way that I can display the results of the query in the form. I am pretty new to VB.Net so any suggestions on where to start would be greatly appreciated.