Golden

In a searchable form, can you add fields from tables other than the source table? For example, my application provides users the ability to pull data into a report based on their selections in listbox fields. One of the form fields I need are located in a different table. I reviewed the information on views and joining tables, but there really is not a relationship that I can establish between the two tables. Users will select job titles from a list box and rates will pull from the source table. The user also needs to be able to lookup a city and state to get a differential (%) that will be used to calculate a new rate for that specific area. I need a field (s) from the table with the differentials that will provide the user with the ability to select city and state so that the differential can be looked up and used in the new rate calculation. I will need a similar set up with another field from another table. I am new to Caspio.