I am using MySQL as back end and have (now) worked out procedures and functions therein to be called from the form to minimise scripting in basic! I am using a “Filter” table as suggested in base handbook. The initial saving of the choice in this file is used to pass data to procedures and functions in MySQL. In one case, for the adding new record I have more than 4 fields to be passed from “Filter” table to the target table. Is there any way to increase the number of master/slave fields.
In one case, for the adding new record I have more than 4 fields to be passed from “Filter” table to the target table. Is there any way to increase the number of master/slave fields.
Yes, it can be done to clone records. Use semi-colons (
to separate multiple corresponding field-names in the link master fields / link slave fields controls of the form properties. For example “PID”;“PRICE”;“VID” as used in DACM’s sample Invoicing_and_Cloning_with_SubForms.odb database in this post.
I think I have not been able to put my question clearly enough. The tool for linking master/slave fields caters for 4 fields to be connected. I need to link 7 fields. Foreign keys from 7 different tables are to be transferred to the target table. I must not transfer these directly as intermediate level additional data is to be typed in. I am reading the data from source files into the single record “filter” table so that an add only table control linked with the filter table reads these. cont
continuing please - I tried to add fields by separating additional fields with “;” but it does not work.
.still does not work in 2020 (LO6.4) 
- adding manually is also quite broken (try it …)