Jump to content
  • 0

Using A View To Search Across Tables



Hi - I have created a view across four tables which I need to pull data from using a  search form.


This works fine if there are only single records in each table per user_ID ... However three of the tables have multiple entries per user and these all show in the results list. 


Is there a way of losing the multiple entries to only show the one record in the results?


ie, I have a calendar entry table with several entries per user, but I only need to see that user once in the results list. I need the calendar entry in the search as I am trying to achieve a date search producing a results list with people available between certain date periods. 


Any suggestions or help will be greatly appreciated?


many thanks



Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Thank you Maymusic..   I do not need the actual calendar record for the results, it is merely referenced in the search to determine availability.

Is there a way in caspio of searching across the date fields in a table to achieve this. I need to produce a list of users available for a time period added in the search. i.e. looking for someone available between 2nd April 2014 thru to 28th April 2014. The search will pick up anyone with nothing entered in that period first ( top of report list )meaning that they are fully available then filter down in order of amount of availability thru that period. 


I am still getting my head around caspio and any help will be fantastic.





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...