Any solutions / considerations for this common design problem.



Business users want to constraint data based on Interface category
pickers. The values in picker B depend on the value selected in picker
A. There can be any number of dependencies; E depends on D, F
depends on E, etc.



Something like this should suffice.



Id,

InterfaceLabel, --helps data administrator

WidgetType, -- helps data administrator

Value, -- display value

Level, -- for readability

fk_id null -- when its null it's picker A





Any thoughts?


--
DISCLAIMER

Confidentiality Note: This e-mail is intended only for the person or entity to
which it is addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. Dissemination,
distribution or copying of this e-mail or the information herein by anyone
other than the intended recipient, or an employee or agent responsible for
delivering the message to the intended recipient, is prohibited. If you have
received this e-mail in error, please notify us immediately (telephone
415-288-0544 or e-mail [Email address protected] and destroy the original
message and all copies.

Hall Capital Partners LLC reserves the right to monitor and review the content
of all e-mail communications sent and/or received by its employees.


MS Sql Server LazyDBA home page