Eliminate ambiguity here {need some ideas}

[imoree]

As you can see , this is starting to become quite ambiguous. Any ideas how i can eliminate this before this gets way

out of hand?

1 Product can have MANY options, there are some Products which share the same Option( this is my issue)

2. using value lists, but perhaps this is not the way !

3. Perhaps my normalization is not normalized enough? if not, how can i normalize better.

Thanks

-ian

[bcooney]

Perhaps introduce a product type, and the type has options.

Products

ProdTypes

TypeOpt

Options

[imoree]

BCooney;

have done some more work, Using GLobals to collect data for entry, Things are looking good right now. Thanks for your 5 cents!

-ian