zoho table

zoho table

Hi,

      My Application is Reservation System, so i want to show my field company_name,occupancy_type,Room_type,etc..,
I got ans for all possiblity, becoz  i give some condition in back end process
         if((company_Name =="aa") &&(Occupancy_Type=="Single_Occupancy"))
{
input.Rate =2300;
}
so i put more condition like this (i have 20 and more company).My another idea is these values store under one table ,so dont giv a condition but that field take this table and display that values.That table get from another form like this
 

Company_Name Occupancy_Type Room_Type Rate
aa Single       Standard 2000
aa Double Executive 2500
bb Single Standard 2300
bb Double Executive 2700

It is possible? Please reply me!

Thank You,