Subsections

[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.