Need help creating a quote form

Need help creating a quote form

I need to be able to look up a price based on the breed of dog and the service level(bath or groom). Ideally I would like to be able to select the breed from the dropdown, then select either bath or groom and the price would then populate.

I have tried this several different ways. I created a table where the record name is "breed - service) and includes a price field. Created another table of just breeds and another of service levels. I then created a form that has a Breed lookup and a Service lookup, I combined the inputs with a formula field and used that to look up the price using the "breed-service" table. I always get an error saying the record wasn't found.

I tried populating the selected breed in another field then in deluge sending that + service to the price lookup, no match.

I also tried putting a formula field in a table listing "breed - service - price" combining breed and service, same result.

Is there an easier way to do this? As you all can probably tell I am very new to this and I'm trying to ease some of my administrative work.

Any help would be appreciated.

on userinput Breed

temp = Breed[ID == input.Breed1];
input.blankfield = temp.Breed;

on user input Service

Pr = All_Services[Formula == input.blankfield + " - " + input.Service];
input.Price = input.All_Services.Starting_Price;


Error details:
Error in executing On User Input script of Level.
Invalid client task found corresponding properties Line:(4)
Invalid value 'Affenpinscher - Revival' found for the variable Formula. Line:(4)
Okay


Thank you!