Hello all,
On my forms I am using a dropdown to constrain the input values of some data fields. In particular the values are foreign keys, and the dropdown has the proper keys and description. I am using that dropdown to populate records in the Invoices table. The dropdown is created by changing the field type to combo box, and the choice of available values come from the corresponding domain table, using the expression
Value + "|" + str(Invoicestateid)
The dropdown works fine on a form for the Invoices table, or in a set containing the Invoices table and a mapped table with customers and addresses. The linking between that mapped table and Invoices is one-to-one.
However, when I add the one-to-many invoicelineitems table to the set with referential integrity set to Cascade Changes/Deletes, and open the form, I find that the drop down does not work. I click on the dropdown and nothing happens (i.e., the dropdown does not open). It does, however, correctly show the text corresponding to the current value in the field.
But if I remove the referential integrity, the dropdown works as expected.
What am I missing? Why is the dropdown (whose choices are coming from a totally different linked table) not working when the one-to-many table has its referential integrity set to none?
I am using SQL backend, where referential integrity is maintained at database level using relationships between tables/fields.
Do I still need to have referential integrity set in the set, or if I can set it to blank?
Any help is appreciated.
Thank you,
Armando
On my forms I am using a dropdown to constrain the input values of some data fields. In particular the values are foreign keys, and the dropdown has the proper keys and description. I am using that dropdown to populate records in the Invoices table. The dropdown is created by changing the field type to combo box, and the choice of available values come from the corresponding domain table, using the expression
Value + "|" + str(Invoicestateid)
The dropdown works fine on a form for the Invoices table, or in a set containing the Invoices table and a mapped table with customers and addresses. The linking between that mapped table and Invoices is one-to-one.
However, when I add the one-to-many invoicelineitems table to the set with referential integrity set to Cascade Changes/Deletes, and open the form, I find that the drop down does not work. I click on the dropdown and nothing happens (i.e., the dropdown does not open). It does, however, correctly show the text corresponding to the current value in the field.
But if I remove the referential integrity, the dropdown works as expected.
What am I missing? Why is the dropdown (whose choices are coming from a totally different linked table) not working when the one-to-many table has its referential integrity set to none?
I am using SQL backend, where referential integrity is maintained at database level using relationships between tables/fields.
Do I still need to have referential integrity set in the set, or if I can set it to blank?
Any help is appreciated.
Thank you,
Armando
Comment