ive had some minor background work with visual basic but not enough to tackle a program ive been asked to create, so i jumped from vb6 to visual studio since it appeared to be a more user friendly environment with more of the drag and drop instead of coding
i have multiple tables in a database (PRC) that reference each other (ditem, item, supplier, polot, podata) and i have added the references and text boxes/data grids to the form, which i will show here:
the problem is when i click the first order in the orno table the lot # does not populate or refresh, it sticks with the amount of lots for the first order. by that i mean in the second datagrid there should now be 3 lots (1,2,3) instead of just 1, that is for the first orno. how can i go about doing this? please keep in mind im new to this? also, i used a datagrid because i want to show as many records as there are to display, so if it would work better to have 5,6,7,8...etc textboxes and a query for each to move to the next record i would do that if i knew how, or if that would work?
thanks in advance for any input