Hi. I have three column with reference type (Aircraft manufacturer, engine manufacturer, propeller manufacturer). These columns is ref to a table called manufacturer where all manufacturer names are listed by categories (Aircraft, engine, propeller).
Let say i want to add Boeing in the list by click on the add button. The app will open the manufacturer form. I want it to automatically choose aircraft for the category. Can i do that?