LinkChildFields/LinkMasterFields - using two

[sumoalex]

Hi all:
This works:
subfrmFindWorkRecord.LinkChildFields = "EmployeeID"
subfrmFindWorkRecord.LinkMasterFields = "EmployeeID"

This doesn't:
subfrmFindWorkRecord.LinkChildFields = "EmployeeID;ApprovalEffectiveDate"
subfrmFindWorkRecord.LinkMasterFields = "EmployeeID;ApprovalEffectiveDate"

Everything I've checked says if you want to use more than one field, separate fields with semi-colons, but I get the following error message:

"You must use the same number of fields when you set the LinkChildFields and LinkMasterFields properties.

You entered a different number of fields for one property than you did for the other..."

What's up with this?

 

[FancyPrairie]

Try doing it without including the double quotes. For example,

subfrmFindWorkRecord.LinkChildFields = EmployeeID;ApprovalEffectiveDate
subfrmFindWorkRecord.LinkMasterFields = EmployeeID;ApprovalEffectiveDate

 

[sumoalex]

Thank you. I tried that. Still no joy.

 

[FancyPrairie]

Stupid question ... Do you have 2 fields on your subform named EmployeeID and ApprovalEffectiveDate? And do you have 2 fields on your main form named EmployeeID and ApprovalEffectiveDate?

 

[sumoalex]

LOL yes (that was my original mistake) but yes I do.

 

[shannonp]

You got this fixed yet? - I had the same problem and worked around it by setting both my link fields to an empty string before passing new values:

subfrmFindWorkRecord.LinkChildFields = ""
subfrmFindWorkRecord.LinkMasterFields = ""

subfrmFindWorkRecord.LinkChildFields = "EmployeeID;ApprovalEffectiveDate"
subfrmFindWorkRecord.LinkMasterFields = "EmployeeID;ApprovalEffectiveDate"

Cheers
Shannon

 

[flaviooooo]

I had the same error, and I fixed it by simply adding a second Master and Child-link in design mode on the subreport.

The error was gone, and I'm a happy man