Skip to main content
Solved

Usability when linking from many to one record

M

Usability problem when linking to a record from the from the ‘one’ end of a many to one relationship.

We visit homes to help people reduce carbon footprint and save money by taking energy efficiency measures.

On every visit we recommend or take one or more actions, each of which has a specific ‘deliverable’  that holds standard values for savings etc.

The entity relationship is:

  • Visit to action = 1 to many
  • Deliverable to action =  many to 1

We have many different deliverables, over 200. When adding a new action, which is usually done using a form that is prefilled with the correct Visit, the Deliverable field presents a long list that is in seemingly random order.

 

I cannot find a way to sort or group the selection of links. Interfaces do not seem to help.

Can anyone advise?  This must be a common issue . . .

Best answer by FarioConsulting

Hi,
You could set up specific views within the Deliverable table and then limiting the selectable records from those predefined views....As such every time you go to add or edit an action, the list will be consistently sorted and organized according to how you've set it up

View original
Did this topic help you find an answer to your question?

3 replies

F
Forum|alt.badge.img
  • FarioConsulting
  • Participating Frequently
  • 15 replies
  • Answer
  • December 4, 2024

Hi,
You could set up specific views within the Deliverable table and then limiting the selectable records from those predefined views....As such every time you go to add or edit an action, the list will be consistently sorted and organized according to how you've set it up

Harsh | farioconsulting.com
Alexey_Gusev
Forum|alt.badge.img+12
  • Alexey_Gusev
  • Brainy
  • 1119 replies
  • December 5, 2024

Hi,
Did you try to sort records in Grid View of Deliverables table?

M
FarioConsulting wrote:

Hi,
You could set up specific views within the Deliverable table and then limiting the selectable records from those predefined views....As such every time you go to add or edit an action, the list will be consistently sorted and organized according to how you've set it up


Thanks - I had tried this before, but today it worked!  The difference is that you must ONLY SORT the view that you are restricting choice by.  If you also have groups in that view, as I did, this messes the presentation order up.

Alexey_Gusev
1 person likes this
  • Alexey_Gusev
    Alexey_Gusev

Reply


Most helpful members this week

Terms & Conditions