Brendan,
It sure would be nice if we could extract data from a linked form to a field. In a calculation field for example:
i.e.
Name = linkedform.Name
Name = linkedform.Initials + ” ” + linked.Form.Name
If this could be done it sure would save a lot of double input.
Leo
Hi Leo,
Except there would be multiple initials and multiple names because what if you have multiple records in the child form? Which row does it get the values from?
Thanks,
Brendan
Hi Brendan,
only applicable to one to many of course.
I link reports and sales to 1 person. (one2many)
Maybe a different field is in order here, a field with 2 variables: link to form.field (selectable)
Leo
Even a one-to-many would imply there are multiple possible values to choose from. Do you mean a many-to-one? I.e. the inverse relationship of a one-to-many?
Yep, the reversed… (the one that’s get you in to trouble ;-))
many to one. I noticed that the many to many could be used for this. (in reverse or not)
but that is what I mean.
Leo