I track changes to a car and those changes are given a construction number. For example, when a car is built it may have a number like LT67334. If any significant changes are made to the car it will be given a new number like Lrr8644.
I have a form that tracks a bunch of information about each car and each car can have one or more construction numbers. So to solve this I created another table that will hold the additional construction numbers and only show the current number. However, my team needs to sometimes filter the form to find any cars that have ever used a particular number, not just the current number.
Is there any way to make this work in a regular filter by form type scenario. Basically I would like to be able to filter the form to show any car that has ever used that construction number even though the number could be in the current form field OR it could be in a separate table.
thanks for any help