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:
Is there a way to build this?
Thanks for the effort