Page 1 of 1

Subform foreign key not visible

Posted: Mon Jan 24, 2022 11:51 am
by Duski
Hi there.
I'm creating a book catalogue with loaning history for each book.

The book catalogue shows a browseedit form named "frm_knihy", background table is "tbl_knihy" which includes a field named "tbl_pozicky_id" planned as foreign key for loanings.
The loaning history shows a form named "frmsub_pozicky", background table is "tbl_pozicky" which includes a field named "poz_id" as a primary key .
I'm trying to include a subform object "frmsub_pozicky" indo edit page of "frm_knihy", but when it comes during setting the subform to the foreign key, dropbox with available fields doesn't contain the foreign key "tbl_pozicky_id" from the main form frm_knihy. I'm not able to finish the subform setting :-(
What I'm doing wrong ?
Thanx in advance.

Re: Subform foreign key not visible

Posted: Mon Jan 24, 2022 12:38 pm
by kev1n
Hi,

Is this question really for nuBuilder Pro (v3) ?

Re: Subform foreign key not visible

Posted: Sat Jan 29, 2022 12:59 am
by kev1n
Hi,

I've moved your question from the v3 to the nuBuilder Forte Forum.

The subform is linked to the main form with a foreign key that is part of the linked table, not the main table.