Menu

Multiselect with composite primary key

+1 vote

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.

in Features (Done) by (2.4k points)
recategorized by
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

1 Answer

0 votes
 
Best answer

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

by (64.9k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...