AnsweredAssumed Answered

Calculated Value List with Favorites

Question asked by hrjacobi on Mar 26, 2012
Latest reply on Mar 29, 2012 by LyndsayHowarth

I have an invoice layout which is connected to my invoice table. Companies are related through the Company ID with the invoice table. Now in the invoice table I have a pulldown (value list) with account numbers (these are in a separate table). Now for most of the companies we always have to use the same account numbers. So I thought that it would be easy to make a value list which starts with some 'favorites' and then follows with the hole list.

So far I've made in the Company table/layout that you can define the favorite accountnumbers with checkboxes which results in one field with only the selected favorites for that company.

At this moment I have a calculation field in invoices which collects the favorites based on the relation to the company en the whole list from account numbers. Because I use a calculated field with relations a Value List doesn't support it and tells me that there's no index.

 

Example how I would like it to work:

Company A:

19198

18818

18183

---------

1324

4567

etc

 

Company B:

09809

07337

---------

1324

4567

etc

 

Is there a way to build this?

 

Thanks for the effort

Outcomes