JediG

Hi everyone. I'm brand new to Caspio coming from Filemaker Pro. I am trying to create a mock storefront in which a user (actually a student) selects an item they want to purchase (not real money) and a new record would be created in the Purchases table. I have all the items for sale in the Items For Sale table and I want the system to look up the price in the Items For Sale table. I can't figure out how to do this. I set up a relationship (based on my Filemaker knowledge) but I have no idea if it's correct. Any and all guidance is much appreciated.