I am creating an application (specifically in FileMaker) that would store information about Vehicles, Drivers and the Trips done by Drivers using a Vehicle. In my Vehicle Details, I have Manufacturer, Model and Vehicle Type. I couldn't really decide if I should use a drop down list or a Look up form. I considered just using a text box for the user to input the Manufacturer, Model and Type details but it would cause inconsistency in the database. If I use a drop down list, I would have to pre-provide the values for the drop down. If I use a Look up, it would be up to the user to input the values.
Which approach would be better?
My actual frustration that comes with this is that I am using FileMaker and not really creating from scratch using a Programming Language (which for me is easier).