"george" <g@g.com> wrote in message
news:et7LxZz1GHA.4924@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> I am trying to design my database to handle dynamic user input. Currently,
> there is the standard order and order details design.  In order details
> holds the product id and other product data.  Each product could have user
> input that needs to be stored and the user input is different for each
> product.  I thought about using a field in order details and store the
user
> input in there using a coding logic.  Any ideas how to store this data?
>
> Thanks
>
>

"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:eWVvTiz1GHA.4748@TK2MSFTNGP04.phx.gbl...
> Please explain what "user input" is.  Is this user comments, suggestions,
> product specs?   What data type is it?
>
> "george" <g@g.com> wrote in message
> news:et7LxZz1GHA.4924@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> I am trying to design my database to handle dynamic user input.
>> Currently,
>> there is the standard order and order details design.  In order details
>> holds the product id and other product data.  Each product could have
>> user
>> input that needs to be stored and the user input is different for each
>> product.  I thought about using a field in order details and store the
> user
>> input in there using a coding logic.  Any ideas how to store this data?
>>
>> Thanks
>>
>>
>
>

"george" <g@g.com> wrote in message
news:u3pDvsz1GHA.4312@TK2MSFTNGP02.phx.gbl...
> Sorry, the data types are strings and its like additional options.
>
> "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
> news:eWVvTiz1GHA.4748@TK2MSFTNGP04.phx.gbl...
> > Please explain what "user input" is.  Is this user comments,
suggestions,
> > product specs?   What data type is it?
> >
> > "george" <g@g.com> wrote in message
> > news:et7LxZz1GHA.4924@TK2MSFTNGP05.phx.gbl...
> >> Hi,
> >>
> >> I am trying to design my database to handle dynamic user input.
> >> Currently,
> >> there is the standard order and order details design.  In order details
> >> holds the product id and other product data.  Each product could have
> >> user
> >> input that needs to be stored and the user input is different for each
> >> product.  I thought about using a field in order details and store the
> > user
> >> input in there using a coding logic.  Any ideas how to store this data?
> >>
> >> Thanks
> >>
> >>
> >
> >
>
>

"Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
news:OakMK3z1GHA.4484@TK2MSFTNGP02.phx.gbl...
> Are you allowing the user to essentially enter various undefined column
> values for different products?
>
> i.e.
> Product1 may have values for color, weight
> Product2 may have values for horsepower, traction control, antilock breaks
> Product3 may have values for flavor, color
> Product4 may have other as yet to be defined values
>
> Is this what you are trying to do?
>
> "george" <g@g.com> wrote in message
> news:u3pDvsz1GHA.4312@TK2MSFTNGP02.phx.gbl...
>> Sorry, the data types are strings and its like additional options.
>>
>> "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message
>> news:eWVvTiz1GHA.4748@TK2MSFTNGP04.phx.gbl...
>> > Please explain what "user input" is.  Is this user comments,
> suggestions,
>> > product specs?   What data type is it?
>> >
>> > "george" <g@g.com> wrote in message
>> > news:et7LxZz1GHA.4924@TK2MSFTNGP05.phx.gbl...
>> >> Hi,
>> >>
>> >> I am trying to design my database to handle dynamic user input.
>> >> Currently,
>> >> there is the standard order and order details design.  In order
>> >> details
>> >> holds the product id and other product data.  Each product could have
>> >> user
>> >> input that needs to be stored and the user input is different for each
>> >> product.  I thought about using a field in order details and store the
>> > user
>> >> input in there using a coding logic.  Any ideas how to store this
>> >> data?
>> >>
>> >> Thanks
>> >>
>> >>
>> >
>> >
>>
>>
>
>