Error Message question

[Guest]

Hi,

What does this error mean in English?
"You must use the same number of fields when you set the LinkChildFields ad
LInkMasterFields properties.
I was able to creat a one to many realtionship between the tables I'm using
but I get this error when I look at the fields in the related table. Also the
field in the Related Table is a calculation from another program. I can't
find a way to get the information I need unless I do the calculation.

Thanks, Regi

 

[Douglas J. Steele]

LinkChildFields and LinkMasterFields is how you link a form and subform so
that the data in the subform depends on the data in the form.

When you specify them, you must have the same number of fields for both
properties.

 

[Guest]

My form and sub form each had 191 records. Any other suggestions?

Is this an error I need to be seriously concerned about?

Thanks for answering. Regina

 

[Vincent Johns]

My form and sub form each had 191 records. Any other suggestions?

Is this an error I need to be seriously concerned about?

Thanks for answering. Regina

Now this seems kinda weird. Amazing coincidence, to have the exact SAME
number of records in both recordsets! So it occurs to me that, just
possibly, you shouldn't be dealing with a subForm at all, but maybe with
two related Tables, or maybe just one Table (with 191 records) and some
extra fields. (SubForms are intended for use with datasets that are
related many-to-one to the dataset in the main Form, and that seems not
to be what you have.)

To be able to give specific advice, though, I'd need to know a bit more
about the kinds of data in your tables. (Just describe the design -- I
have no wish to see somebody's personal information!)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.