We've implemented one of them with no problems however the second one seems has an issue with a particular combination of tables. The lookup and relationships are created just fine with the API and mostly work as expected however when we place a the multi-table lookup field on a form, it only allows the user to select rows from one of the tables that the lookup references.
We have a support ticket underway and have undertaken a bunch of troubleshooting steps but so far have been far less than helpful.
I was just wondering if anyone else has experienced this or if there are any known constraints on multi-table lookups that might help explain our situation.
Multi-Table Lookup, Form control only displaying one of the tables.
It sounds like you're encountering an issue where the multi-table lookup field is not allowing selections from all intended tables on the form, which can be a frustrating limitation.
only work around - try creating a separate single-table lookup field for each table as a temporary workaround. Although this is not ideal for long-term use, it may help identify whether specific tables or table relationships are causing the problem.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.