This might not be the right place to post this enchancement request, so I
apologize in advance.
The scenario:
Table A: (Parent)
RowID
TabAColumn1 PK
TabAColumn2
TabAColumn3
Table B: (Child)
RowID
TabAColumn1 FK
TabBColumn1
TabBColumn2
When I place these two tables in a form (wherein Table A is the first table,
and Table B is the second table), the RBase engine automatically links the
two tables with RowID and TabAColumn1.
Would it be possible if the developer gets to "tell" the RBase engine which
columns to link the two tables in the form?
The work around I have been using is making a view of Table B without the
RowID column of Table B and using that view as the "second table" of the
form.
And, no, changing the RowID column of Table B to say... RowIDTabB is not a
feasible option for the application.
When creating a view, we can specify what columns to link the tables... I
was just wondering if we can do the same with the forms.