Lookup widget not working in related table.
Posted: Sat Apr 09, 2011 7:25 amHi Steve,
I have three tables: Company, People and Roles. Each people can have multiple roles, and each role is related to one company.
I've done a lookup widget in Roles table that looks up in Company registers and works as expected when adding new role to parent table Roles. The problem is that the same lookup widget is not shown when add new form is accessed through 'add new roles record'.
Is there a limitation in lookup widget that only allows to be used when table is the parent one and not in related?
Thanks.
I have three tables: Company, People and Roles. Each people can have multiple roles, and each role is related to one company.
I've done a lookup widget in Roles table that looks up in Company registers and works as expected when adding new role to parent table Roles. The problem is that the same lookup widget is not shown when add new form is accessed through 'add new roles record'.
Is there a limitation in lookup widget that only allows to be used when table is the parent one and not in related?
Thanks.