I am an access newbie
I have volunteered to work on a database for a local police force
This very plain database has a form to submit an "incident report" with a bunch of fields. They have been manually adding "vehicles (VIN, color, model etc)" in a comment section.
I think they are better off having a separate table of "vehicles" to link vehicles to each incident report. Some incident reports might have many vehicles, or only 1, or none.
I have created a separate table for "vehicles" with all necessary fields, and entered some random data.
I want to open my "Incident Report" form and simply attach a vehicle from my vehicles table, or add a new vehicle.
In the end I want to browse my incident reports, and see all the linked vehicles for each report.
I cannot seem to get my "Incident Report" form to easily enter a vehicle that saves and is attaches to each incident report.
I tried creating a subform but it doesnt save the data, and is always blank, when I return to that incident report.
I tried another subform linking to the "vehicles" table, and somehow ended up getting this error about invalid expression too complex....
I feel like this is easy, but I just dont know the right path.