Home End User

Force Field Inclusion

edited July 2010 in End User
When a user adds a table is there anyway to force the inclusion of fields
used in joins?

Ken



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5319 (20100728) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Comments

  • edited July 2010
    The DataDictionary AutoJoin feature can be used to automatically join on
    pre-determined fields. This also works for autolinking queries.

    For an example run Demos\EndUser\AutoJoins



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2010
    Nard,

    I do use the autojoin and it works fine when an end user creates just one
    set of data however, if they create two or more so that subreports can be
    used and the join fields are not included, the data diagram obviously cannot
    show the auto joins!

    Ken

  • edited July 2010
    Thanks for providing more detail. There currently is not a way to force the
    joinable/linkable fields to be included in the Select field list of the
    query. Perhaps something we should consider adding for a future release.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    "

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.