First, I feel like I have completely lost the plot! Here’s the problem:
Main window with 6 buttons, one for each line (line 1 thru line 6)
A container with a dropdown in it - I want the dataset to be related to the line selected by way of the buttons.
ie. press button for line 1 and the dropdown is populated with a “SELECT this, that and the other FROM thisTable WHERE location = Line 1”
same for the other lines…
For some reason, besides the obvious (me being mindless and all) , I can’t get it to work properly.
then after setting that straight, there will be an another dropdown that is populated based on the selection of the first dropdown, then a box for a numeric entry - and to wrap it all up - insert the record back to the associated db tables! whew!