Jump to content
  • 0

One search for multiple tables



So I know how to do bits and pieces of this, but there's a big blank when it comes to main part.

I'd like to have a dropdown menu that given a selection will return a search of the corresponding table.

Each table has different fields, but a couple common fields between them -- Publication and TitleID.

Is this even possible of do I need to create a reports data page for each table and then wrap them in a search?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

So I created a relationship between the tables, though I don't know what to do from there. I don't see any options to use a relationship in either the Data Page Wizard or in the View Wizard.

I also created a View, and seem to have some success there with returning results from one table by passing a parameter, though I also get fields from other portions of the view that don't relate to the search results, and I don't know how filter the fields returned in the search results based on the search.

Link to comment
Share on other sites

  • 0

The relationship makes it easier when creating a View to populate the joins and join types. After you have created a View which joins these tables you can open the View and make sure it is returning the desired results, if not you may want to edit the View and change the join types or add filtering to get the desired results set. Then you can create a Search/Report DataPage and use the View for the data source of the DataPage and select your search, results, and details page fields accordingly.

To learn more about creating Search and Reports, please refer to http://howto.caspio.com/datapages/creat ... -datapage/.


Bahar M.

Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...