0

Use a custom view for table lookup

Currently, when you do a lookup to a table (by reference or in global search), the first seven data fields are displayed in the columns. It would be very nice if you could specify these fields, eg. in a view called "lookup" or something similar.

My main inventory table uses references to 2 other tables to build up the main key and primary data. The following real data fields are properties of the combination, and don't aid in determining the correct record. So each time I do a lookup and search for the record, I have to press "show colums" and add 2 additional columns to be able to get the correct record. Saving these additional columns would also be a good alternative.

2 replies

null
    • pbosch.1
    • 4 yrs ago
    • Reported - view

    When you are in Admmin mode you can change the columns, even set filters or functions, like in a normal table view.
    But you must activate adminn mode, befor you click for the lookup.

    Regards Peter

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    After you make your changes in admin mode be certain to always click the LEFT SIDE of the big red "Save" button. Do not click the right side of that button, because doing so will "Revert" you back to your prior settings. I do not know why a single red button performs two different functions.

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1199Views