Forms, multiple data for one text box

[kplatt]

Hi, I have a form, where for each record there is one particular data point for each combo box in that record except one. One Text box will require multiple data points that i would like to make quantifiable. For example, lets say 100 and 200. I was thinking there would be a way to make something like a reverse combo box/sub form which drops down a table for multiple data entry points. Is this possible? I am sure there is a post out there regarding this issue but i cant find it by searching. My hunch is that this data would be stored in another table related to the key element in the form. Any help would be appreciated. thanks

 

[MStef]

As I can understand you, yor table is not normalized well. Learn something
about DATABASE NORMALIZATION.

 

[kplatt]

I dont think that is the problem. I am just asking how to do something. My data is not redundant. should i make another sub table/sub form that will open with a command button to enter multiple date for the Text box and link it through a child? Thanks