Good day all!

I'm quite new to Nin\ox and have a question. I am creating a databse for quoting, invoicing and job profit/loss on individual projects. We are a company making high-end furniture, lighting and other things for some top-level interior designers and private clients. A project could be a one-off dining table of light. Other project may have multiple components as for a condo sales centre, for example.We have divided our time tasks, I guess this would be a "Parent Table" (still not completely clear on what this actually does or means), that conatins five seperate main tasks, Woodworking, Metalworking, Pre Time, Jig Making and Client Liaison. I would create a Choice Combobox with those five elements. Next to it I would like another Choice Combobox that, if the first one was chosen as "Pre Time" it would only show the "Pre Time" tasks, namely, Design, Client Meetings, Drawings, Internal Meeting, Materials/Supplies Sourcing. If the first Choice Combobox was Woodworking, the second would automatically be polulated with the Woodworking tasks, namely (only a selection, the actual list is much longer), Material Purchasing, Cutting, Cleaning, Sanding Pieces, Planing, etc, etc.

I've attached a scren grab of my Excel spreadsheet I created as a proof of concept.

Is this possible? Is there a better way of doing this?

Thanks!

Marek