I know this type of question has come up before but I am still very new to this and I can't seem to figure out how to make it work.

I am designing an Order Entry Database for my Fabrication Job Shop. I have Two Fields in the Order Entry Table. Field One is "Sales Type" which includes Fabrication, Rolling, Stress Relieve, Burn Outs, and Miscellaneous which appears as a pop up menu from a Custom Value List.

Once you choose the Sales Type, I would like the Second Field to disply detailed information for each sales type. So if "Fabrication" was selected from the first field, only fabrication descriptions would come up.

It seems I need some sort of self-joining relationship but I just cannot figure it out. I'm not even sure if this is the right way to set this up. I could really use some help in a dumbed down way so I can figure it out.

Thank you very much

You need one table that has a single record for each Sales Type and Description combination. Then you create a relationship from your main table to the SalesType_Description one, based on the Sales Type field. Then make your value list contain values from SalesType_Description::Description, 'starting from' your main table.

Ok, I got it now. Once I went through it actually seemed easy. Thanks for making the steps so simple and straight forward.

Thanks again.