ArdeviaForum

Restricting Lookup List items - Restricting Lookup List items based on a column value in the lookup list

Discussion created by ArdeviaForum on Aug 11, 2016
Latest reply on Aug 11, 2016 by ArdeviaForum

Original Post by Sandy (Imported from Ardevia Forum)

Hi,

 

I would like to restrict the items available for selection in a lookup list to those with particular attributes.

 

Invoice List

 

Account

Description

Amount

 

 

Account List

 

Account Number

Account Type (expense, revenue, general, other)

 

 

The Account column on the Invoice list has a lookup to the Account Number column on the Account List. However, I only want to be able to select items from the Accounts List that have a type of expense or other.

 

How do I restrict this?

 

Thanks

Sandy

Outcomes