Multiselect with composite primary key

Question

Does dbFront support multiselect lookups, where one of the relationships consists of a composite primary key? I tried setting it up but it's only showing as One to Many. Not sure if it's unsupported or I'm doing something wrong.

Comments

Hello Daniel, what fields types are you using for your Composite key?   After some testing it looks like dbFront partially supports it.  dbFront sees it at both ends but only allows your to add the relationship to the form on the simple side.

---

it's a 3 way composite primary key on one side, 2 int and 1 smallint. The other side of the relationship is a single int column

Answer 1

As of version 1.4.0.0186, dbFront now automatically handles composite keys in Multiselect fields.

If you encounter any issues then please let me know.

For more details on creating a Multi-Select see. Multiselect Lookups/Dropdowns