Hello!
I am currently at a standstill. To make my long story short... I have a database that keeps track of vehicles and equipment. This included Maintenace records, mileage, locations, etc. (Keep in mind I am not the only one who uses it) Because I have seniority with it, I am more familiar with it. However, I have come across a problem. In my database we have a tab names Mileage where we keep track of the monthly mileage for vehicles that we will be submitted to an outside program. I created a form to send out to employees that are responsible for vehicles (1 employee, 1 vehicle). This form automatically creates a record into the tab which I like but I do not want it to do that. or at least want it to do something else.
I would want to do the following or get close to it:
- list of vehicles showing the 49 vehicles that need mileage information.
- The mileage that gets submitted through the form updates the list (this would have to be monthly, and we cannot delete the past month)
- Flags the vehicles that need mileage information.
I have tried creating another base that syncs with my main base, but I can't get it to work. I have also tried creating a monthly place holder that would merge with the form data but have been unsuccessful.
Any suggestions would be greatly appreciated.