Creating conditional code based on form selections in the same page

Creating conditional code based on form selections in the same page

I have a product selector where there are four fields:

Category
Item
Price
SKU

Each SKU is a unique combination of Category and Item. 

I'd like to create a field that automatically populates the Price and SKU based on pulldown selections of the Category and Item.

If I were able to code it in SQL, it would look something like

SELECT SKU, where Category={pulldown.category} and Item = {pulldown.item} AS SKU

SELECT Price, where Category={pulldown.category} and Item = {pulldown.item} AS Price

I'm not sure how to make this work in Creator.

Any ideas?

Thanks!