With Firebird 3 embedded, using the form wizard, I cannot select the option “Sub-form based on existing relation” (in the 2nd dialog). It’s greyed out/disabled. The other option, “Sub-form based on manual selection of fields” is enabled.
I have no such problem with HSQLDB. The first option is enabled, and lists child tables that apply.
I’ve also tried registering the FB3 database, but it didn’t help.
It’s more out of curiosity. I have no qualms about creating a subform manually, via wizard or design view. Having designed my tables personally, I know exactly what relationships are involved with any table. I’m just wondering if there are any advantages to using that first option, that I’m not aware of.
Any ideas? Thx