I am creating an application but having some trouble.
This is part of my form that I am having issues with:
View attachment form.bmp
I have a combobox that has some data in it. I want the user to select an item from the list, click add, and have it show up in the listbox, but also to my db table on save.
Here is a look at the dataset designer:
View attachment designer.bmp
As you can see, my main table is flightplan. I have an intersecting table and then a lookup table.
A flighplan can have multiple chargenumbers and charge numbers can belong to several flight plans. Many to Many.
The form is bound to flight plan, so the user opens to form the add a new flight plan. They will enter some other info and then select charge numbers associated with the flight. What is the best way to do this. I have the chargenumbers and its associated id already in the drop down. I just dont know how to work the add and how to display that selected item in the listbox.
Right now, I have the user save the flight plan with basic data they enter, then when they click save and continue, this groupbox shown in the image is enabled. I was thinking maybe i needed the id of the flight plan before i could add items to the flightcharge table.
I am all confused. I can do it all with sql, the old school way, but I am trying to learn how to use datasets and databinding, etc. This is just one of the items i cant figure out. Any help or guidance would be greatly appreciated.
This is part of my form that I am having issues with:
View attachment form.bmp
I have a combobox that has some data in it. I want the user to select an item from the list, click add, and have it show up in the listbox, but also to my db table on save.
Here is a look at the dataset designer:
View attachment designer.bmp
As you can see, my main table is flightplan. I have an intersecting table and then a lookup table.
A flighplan can have multiple chargenumbers and charge numbers can belong to several flight plans. Many to Many.
The form is bound to flight plan, so the user opens to form the add a new flight plan. They will enter some other info and then select charge numbers associated with the flight. What is the best way to do this. I have the chargenumbers and its associated id already in the drop down. I just dont know how to work the add and how to display that selected item in the listbox.
Right now, I have the user save the flight plan with basic data they enter, then when they click save and continue, this groupbox shown in the image is enabled. I was thinking maybe i needed the id of the flight plan before i could add items to the flightcharge table.
I am all confused. I can do it all with sql, the old school way, but I am trying to learn how to use datasets and databinding, etc. This is just one of the items i cant figure out. Any help or guidance would be greatly appreciated.