Search the Community
Showing results for tags 'unique'.
I have a data table with that could have multiple locations for a physician. From that data table I would like only one unique physician name display after the user enters their search criteria. From the list of names that match the criteria I would like the user to select the physician name and on the next page have it display all of the locations for the physician. From that list of locations the user would select one and have the details display for the location. How do I build the first query to get the unique physician name that matches the criteria? In SQL I could use distinct, but I don't see that as an option when building a view.
I am using a Tabular Report to view data, and update some fields. There is a field I want to use as a unique key to a lookup table and display the description from the lookup. For example, I have rows of data regarding trees. For field tree_name e.g. "Oak Tree" I want to display the Latin Name which would be contained in the lookup table "trees_and_latin_names" with key of tree_name (and another field with the Latin Name in it) . Having solved this, if there is no value in the Tabular Report, I'd like the user to be able to type in their own value, this being written to their own data (not the lookup table "trees_and_latin_names". Any help would be appreciated ! Thanks, Mike.
I followed the Facebook like button tutorial found here http://howto.caspio.com/tech-tips-and-articles/social-media/add-a-facebook-like-button-to-your-datapage/, but when the like button is pressed it links back to my site with the correct external parameter in the URL string but it's not going directly to the details page for that item. Need to figure this out. Thanks.