Making an input in one table the field in another.

[bflemi3]

I am tracking contract requirements. One requirement could be acquisition. There are sub requirements under acquisition. Not sure what the best way to do this is, but I think I should input data into one table (e.g.: the acquisition category) and that automatically creates a new field in another table (acquisition sub category). Is this possible to do?

Thanks for your help in advance.
...Still learning

 

[bflemi3]

OK...I understand. That would be much easier.

But, would there be a way to do it the way I want to? The Form will be for the president of my company and I think it would be easier and more organized for him if there was a main category chosen from a list that produced another sub category list.

Thanks for your patience.

-B