How do I show records in reverse order in the record picker used in grid edit mode?
I've tried making a report to use as the record picker, but grid edit seems to use the default record picker despite what I set up .
Forum Discussion
Evan,
The record picker is a drop down type.
The situation is this:
- Start on the form for editing a time card record. This form includes a table of individual time allocations that are related to the time card.
- Click "Grid Edit" at the at the top of the table for related time allocations. We now see an editable table of the time allocations related to this time card and blank rows where new time allocations can be created. We want to add a new time allocation.
- On the first blank row, double click on the cell for Related Time Card.
At this point, a drop down list of all time cards appears with the most recent at the bottom of the list. Of course, it's one toward the bottom of the list that always needs to be selected.
Changes that I make in the Time Card table advanced properties for fields to include in the record picker have an effect on the content shown, but I haven't found a way to reverse the order or use a report to populate the record picker.
An alternative solution that would be great is to have the Related Time Card field automatically be set to the same value as all the others in the filtered list that the user sees.
Any solutions you can offer are appreciated.
Regards,
Dave
The record picker is a drop down type.
The situation is this:
- Start on the form for editing a time card record. This form includes a table of individual time allocations that are related to the time card.
- Click "Grid Edit" at the at the top of the table for related time allocations. We now see an editable table of the time allocations related to this time card and blank rows where new time allocations can be created. We want to add a new time allocation.
- On the first blank row, double click on the cell for Related Time Card.
At this point, a drop down list of all time cards appears with the most recent at the bottom of the list. Of course, it's one toward the bottom of the list that always needs to be selected.
Changes that I make in the Time Card table advanced properties for fields to include in the record picker have an effect on the content shown, but I haven't found a way to reverse the order or use a report to populate the record picker.
An alternative solution that would be great is to have the Related Time Card field automatically be set to the same value as all the others in the filtered list that the user sees.
Any solutions you can offer are appreciated.
Regards,
Dave