The ability to input a new record into my maintenance table requires choosing a record to link from my assets table. The issue of using auto number Unique Id’s for each table means the linked record search is not very useful. I have a table of more than 100 assets of different types. The “find a record to link” search function only lets you search according to the unique id, without being able to thin the search down by using the other columns like Type, or Asset Designation, or Manufacturer or Serial Number.
I believe a suggestion was made to allow a user to create a filter for the “find a record to link” search, but I think simply expanding the search capability beyond the first column would be ideal.