Announcement

Collapse
No announcement yet.

Possible Bug: Forms N-to-N Relations

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Possible Bug: Forms N-to-N Relations

    Used the wizard and instructions for adding N-to-N (many-to-many) relations on a form application.

    Seems the problem is originating from the first step in the wizard. It asks for Field Name, Type and Label on the first step. Followed all the steps in the wizard and to the notes everything is matching (done the wizard at least 12 or more times).

    Here is the error message I get when generating the form.

    Link Table table / fields missing:itemdatabase_itiid. see screen shot attached. Screen Shot 2013-02-11 at 10.00.20 AM.jpg

    doesn't matter what field name I use (except you cannot use a field name from the table (i.e. itiid).

    Can't figure out what I am doing wrong.

    Kris

  • #2
    Possible Bug: Forms N-to-N Relations

    See thread:
    http://forum.scriptcase.net/showthre...to-N-Relations

    Comment


    • #3
      Found the problem....the documentation doesn't state that the field name must match the table name of the linked table.

      Example:
      itemdatabase
      -itiid (pkey)

      itemdatabaseshared (the field name must match this name)
      -itiid
      -wtiid

      workordertypes
      -wtiid (pkey)
      -wtsDescription

      Comment


      • #4
        Hello austin,

        Were you able to solve the issue? If so I will check on the documentation problem.

        regards,
        Bernhard Bernsmann

        Comment

        Working...
        X