Question Field within a field

[sara27]

Hi, newbie question I have a field, Requirements and Tolerances but I need this fild to have 5 sub-fields - Water, Light, Wind, Salinity and Drought. How do I do this if it is possible.
Thanks
Sara

 

[RuralGuy]

Have you looked at any descriptions of Normalization?

 

[sara27]

I have looked at descriptions of normalisation but I'm not sure if I'm understanding your point. Are you suggesting I should create a table for Requirements and Tolerances? Perhaps if I explain a bit better what I'm attempting to do. I have a plant database. I have a table for each category of plant, trees, shrubs etc. I have have done it this way for the user so they can, when entering data, initially select the main category. One of the fields in each category is Requirements and Tolerances refering to the conditions for planting eg. water, wind etc. These will be different for each plant so I don't see how a separate table will help.
Again please forgive my ignorance.
Sara

 

[RuralGuy]

Hi Sara,
You had mentioned SubFields. I'm not sure what you mean. There should only be one value in a field however that value can be different for each record. Maybe if you give a short example of what you need it would help me understand better.

 

[sara27]

I think I will have to have separate fields for each condition as I don't see any other way. My problem was how to make it easier for user input (I'm going to be using the database in a VB application.
If anyone has any other ideas please let me know

Sara

 

[RuralGuy]

Are there a finite number of responses for each field? If so then using ComboBoxes so the user can select from a lookup table could aid input.

 

[sara27]

Yes I think a combo box would be the best solution. I will do a mock up and see how it will work
Thanks for your hel[p
Sara

 

[RuralGuy]

Let us know what you think.