Alpha DevCon 2018
Results 1 to 3 of 3

Thread: How to build a view for searching

  1. #1
    Member
    Real Name
    Mark Gallagher
    Join Date
    Feb 2017
    Location
    Sarasota, Florida
    Posts
    30

    Default How to build a view for searching

    Background ...

    I have 3 Alpha Five tables that share a few common fields. I'd like to build a view that combines these tables
    and enable us to search on the common fields. I have played around with Alpha Five sets but I do not think
    using sets is the solution. I do not see any tools that would allow me to build a view. I have also observed that
    when you build a form Alpha Five only allows for a single table source and that is pretty much how all the applications
    were developed in this shop.


    Questions ...

    Where in my AlphaFive Version 10 Desktop software development tools can I build a view I can search on from a form?

    Am I right to conclude that Alpha Five only allows one source table per form?

    Thanks

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,954

    Default Re: How to build a view for searching

    There are no views in Alpha, only forms and browses. (disregarding reports, letters, and labels)

    An Alpha layout can be based on a set or a table. Filtering and ordering a browse or form based on a one to many set can be problematic. Since a set contains no data and consumes little space it often easiest to have multiple sets defined for the same group of tables with various of those tables as the parent of the set.

    If the information you wish to view is from one to one relationships you should investigate mapped tables.
    There can be only one.

  3. #3
    Member
    Real Name
    Mark Gallagher
    Join Date
    Feb 2017
    Location
    Sarasota, Florida
    Posts
    30

    Default Re: How to build a view for searching

    Mapped tables, this just may allow me the functionally I am looking for in a view. Thanks Stan!

Similar Threads

  1. PhoneGap Build no longer works in version 12.3 Build 2682
    By richardurban in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 07-07-2017, 12:03 AM
  2. Replies: 8
    Last Post: 04-27-2017, 09:26 AM
  3. Demo Sample Automobile Inspection App not working with Build 3419/4614 nor previous build
    By kctermite in forum Tablet-Optimized Form Capabilities Beta
    Replies: 2
    Last Post: 02-15-2016, 12:10 PM
  4. Cannot view Sets with the new Build...
    By awj in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 01-31-2010, 07:02 AM
  5. Locating / Searching in View Mode
    By Charese Dorsey in forum Alpha Four Version 6 and Prior
    Replies: 1
    Last Post: 01-09-2003, 11:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •