Subsections (1 Viewer)

[StuartG]

Hi all,

I have been tasked with implementing a new field into our DB but not sure how to do it. Hopefully I can explain my requirement here.
If the user selects "Biopharma" I only want them to see the results listed in the "Market Sub-Segment and so on.

Market	Market Sub-Segment
Biopharma	Bioanalysis Large Molecule
	Development
	Discovery
	MAM
	PAT
	QC / CMC
	QC/CMC
Environmental	Air
	Drinking & Groundwater
	Soil
	Solid Waste
	Wastewater

Would I need to create two new columns in the table for the Market and Market Sub-Segment?

Any guidance would be appreciated.

Stuart

 

[arnelgp]

see Form1 on the demo.

 

[StuartG]

see Form1 on the demo.

Thanks Arnel. Will I need to create two separate tables or can I add the info to an existing table in our DB?

 

[arnelgp]

you can have it in a single table.

 

[Pat Hartman]

Just because you can, doesn't mean you should. Market needs a table to define its unique population. SubMarket needs a table to define its unique population. This table includes a foreign key named "MarketID" to reference the Market it belongs to. If you do not use two tables, you have no way of defining the unique set of Markets easily. You will leave yourself open to typos when creating entries in the table.

This is a technique called "cascading combos". There are many examples.