Error Message question

R

Regi

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
 
D

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.
 
R

Regi

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
 
V

Vincent Johns

Regi said:
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
Click to expand...

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.
 
Top