new record from filtered data

[nena]

Merry Christmass to everybody!

Here is my question.

FMP7.

A table contains one field named "products" with different, but repeating records. Another field -"price" can have different values for the same product.

I would like during data entry for a new record first to choose a product from a pop-up menu. That's easy.

What I can't is to make the "price" selection from another pop-up menu displaying the existing prices for the selected product only.

Will somebody help me with this?

[aaa]

Hi, nena!

Read about condition list.

[nena]

Aaa,

Thanks for the direction.It works now.

But more questions are to come.

Выше гор могу быть только горы

на которых еще не бывал.

[aaa]

Кто вы?