Hello, I have been gone quite a while from starting out using Alpha I never actually finished any apps yet, a couple years back I was trying to learn how to use Alpha and MySQL and SQL Server, the partner I had lost interest in our project. I am back with several new ideas that I believe can be accomplished using Alpha, I know I will have to upgrade to get the features I will be needing. So you know I am still new to this and realized that I had to learn how a Database should be structured and relationships work, so last fall I took a class on Database administration and design so that I had a better understanding. I am not an advanced user so please take it easy on me.
Now what I am trying to accomplish is....
I want to use a cascading or dropdown listbox type of entry, to for example- add items to inventory. My question is do I make a separate table that is used to supply the dropdown or cascading boxes with the values that are then saved to the inventory item's own table?
One reason I ask this is I believe that it would be then easy for me to make a separate form type way to make changes and manage or add fields to the supplying values?
Or would I be best off to make a table with all of the category choices and it supplies the cascading(dropdown) values and just saves the inventory items number in the category table as a foreign key?
or should all the choices be stored in the listbox itself and then saved to the database in the inventory item's table or a separate category table?
I am curious how others have done this, please don't over "technitalk" me suggestions because I may get lost in your explanation.
Thanks for any input in advance.
Jerrod
Now what I am trying to accomplish is....
I want to use a cascading or dropdown listbox type of entry, to for example- add items to inventory. My question is do I make a separate table that is used to supply the dropdown or cascading boxes with the values that are then saved to the inventory item's own table?
One reason I ask this is I believe that it would be then easy for me to make a separate form type way to make changes and manage or add fields to the supplying values?
Or would I be best off to make a table with all of the category choices and it supplies the cascading(dropdown) values and just saves the inventory items number in the category table as a foreign key?
or should all the choices be stored in the listbox itself and then saved to the database in the inventory item's table or a separate category table?
I am curious how others have done this, please don't over "technitalk" me suggestions because I may get lost in your explanation.
Thanks for any input in advance.
Jerrod
Comment