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.

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

Screen Shot 2013-02-11 at 10.00.20 AM.jpg

Possible Bug: Forms N-to-N Relations

See thread:
http://forum.scriptcase.net/showthread.php?3578-Possible-Bug-Forms-N-to-N-Relations

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

Hello austin,

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

regards,
Bernhard Bernsmann

I can confirm by naming the field same as the relationship table works. This is not mentioned anywhere!