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.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
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.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.