Ask Your Question
0

How to increase the number of master/slave fields in forms? [closed]

asked 2014-10-12 16:23:32 +0200

PChitnis gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 20:21:26.638588

1 Answer

Sort by » oldest newest most voted
0

answered 2014-10-14 03:14:22 +0200

frofa gravatar image

updated 2014-10-14 03:23:43 +0200

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.

edit flag offensive delete link more

Comments

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

PChitnis gravatar imagePChitnis ( 2014-10-14 15:44:08 +0200 )edit

continuing please - I tried to add fields by separating additional fields with ";" but it does not work.

PChitnis gravatar imagePChitnis ( 2014-10-14 15:50:50 +0200 )edit

Question Tools

2 followers

Stats

Asked: 2014-10-12 16:23:32 +0200

Seen: 513 times

Last updated: Oct 14 '14