Filetering a field depending on another field

[scottappleford]

Hi

Not sure if this is a form or table query, so here goes...

I have an invoice table and then an invoice line items table.

In the line items table I have field 'work order number' i.e. each line item will have a corresponding work order number. The db at the moment gets these numbers from a look up table and that table also has a description for that work order number i.e. nr 123 is for surveys and studies.

Now surveys and studies may have three sub headings but the work order number is an umbrella for the main task description and sub taks. The sub taks do not have there own number and at present i can not give them there own number.

Becasue you may have upto 10 different work order numbers for a project and upto 5 sub headings this equates to 50 + sub headings. What I would like to be able to do is that when the work order number has been chosen this filters out the sub headings belonging to that work order.

I am just unsure how to set this up as at present the work order number is a look up with the main heading.

Do I make work order a table in its own right and link that to the line items and then have a lookup for sub headings linking to the work order table??

Thanks for your help.

reading this back it does sound more like a table query??

Kind regards

scott

 

[obeylele]

May be this is what you want,
Hope it helps you