1 of 1 people found this helpful
I now have the followed fields that show up on the job record:
I have the same fields for the second and third trips, and I'm using a drop-down to determine which fields to display at any given time. All of that makes sense and works fine while on the individual job record.
It may look like it makes sense, but in the long run this is hard to maintain and brings (as you have experienced) certain problems.
You should create a related ProjectTrip table where you only need one generic set of these fields:
and can add as many trips as you like for any project.
There you can also search by whatever criteria you like … crew name, duration, project (from the Project table), and, of course, date.