Create a list box from a count/lookup table

[darren_dixon]

Hi,

I have a lookup table with the following data:

PropertyID     Bedrooms

202123          1

202123          1

202123          1

303567          1

303567          1

When I count the bedrooms of these properties I have the following:

202123          3

303567          2

How can I create a list box where the user can select 2 bedrooms from a drop down menu?

Thanks in advance,

Darren

[#2 · Accepted solution]

Put an expression in the listbox:

=AGGR(SUM(Bedrooms), PropertyID)

Cheers