Subform LinkMasterField Error

[Don Fiordelisi]

Hello,

I am working on a project the requires a subform in a
Master form and everytime the subform is entered and an
entry made the following message appears, (it only appears
when entering a new record not on editing of an existing
record) 'The LinkMasterFields property setting has
produced this error:'The object doesn't contain the
Automation object 'Measurements.'' (Measurements is the
name of the master data table.)

I cannot find this error anyplace and am trying to resolve
this issue. Can some one please tell me what thismeans
and what needs to be done to solve this problem.

Thanks you!
DGF

 

[Kelly]

Hi,

You know a lot about subforms? Sorry I can't help you
with yours but maybe you can help me with my problem?? I
get an error "specified field could refer to more than
one table in the FROM clause of your statement. (But it
isn't true).

Can you help? Thanks...

 

[Guest]

I think I have received the same message from time to
time. If I remember correctly and you are using a query
the field is being displayed more than once in the query
table. Just de-select the field from being displayed and
you should be fine.

If you are not using a query, I am sorry, but I cannot
help with this one.

Good luck!
DGF

 

[John Vinson]

Hi,

You know a lot about subforms? Sorry I can't help you
with yours but maybe you can help me with my problem?? I
get an error "specified field could refer to more than
one table in the FROM clause of your statement. (But it
isn't true).

Please post the SQL view of the Query upon which your subform is
based. I strongly suspect that you have two tables joined, and that
you have included the linking field from both tables in the Query. If
so, you need to use [Tablename].[fieldname] to disambiguate, or else
omit one (probably the "One" side table field) of the two instances of
the joining field.

 

[Don Fiordelisi]

Hi John:

Thanks for your help. This seems to be a very frustrating
situation on my side. I have tried everything I know of.
Below is the SQL view contents of the Query. I hope you
can figure this out.

My thanks!
Don

SELECT Measurements.*, SLA_Criteria.*,
Non_STEP_Act_List.*, Measurements.Identifier
FROM (Measurements INNER JOIN SLA_Criteria ON
Measurements.Identifier = SLA_Criteria.identifier) LEFT
JOIN Non_STEP_Act_List ON Measurements.Identifier =
Non_STEP_Act_List.Identifier
WHERE (((Measurements.Creator) Like IIf(IsUserInGroup()

-----Original Message-----

Hi,

You know a lot about subforms? Sorry I can't help you
with yours but maybe you can help me with my problem?? I
get an error "specified field could refer to more than
one table in the FROM clause of your statement. (But it
isn't true).

Please post the SQL view of the Query upon which your subform is
based. I strongly suspect that you have two tables joined, and that
you have included the linking field from both tables in the Query. If
so, you need to use [Tablename].[fieldname] to disambiguate, or else
omit one (probably the "One" side table field) of the two instances of
the joining field.


.

 

[Don]

Hi John:
Unfortunately I have just gotten back to this issue and
want to thank you for your help. As I figured it was
something simple to a pro, but to a novice, well.....

My thanks for your help.
DGF