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.
dbFront does recognize a composite key in a Many to Many (M-M) relationship but it is not able to create the correct UI for a Multi-Select widget.
A good work-around is to add an Autonumber field to the table with the composite key and create a Unique index on that Autonumber field.
You can then setup the associate table using the Autonumber field instead of the composite index.
For more details on creating a Multi-Select see. Multiselect Lookups/Dropdowns