Made a relation on a table and a form stop working?

[Abraham Zwygart]

I have a form called AKRInventPieceSum. That uses a table with the same
name. The primary key is ItemId and InventDimId. In the following two forms:
InventOnHandItem (sys level, except a button), AKRInvByAttributeOnHand, they
both call the same menu item passing InventSum table.
If I add a relation to AKRInventPieceSum back to InventSum using ItemId and
InventDimId (to help with linking from InventSum to AKRInventPieceSum), the
from AKRInventPieceSum stops working when called form InventOnHandItem, but
continues to work when called from AKRInvByAttributeOnHand???

In the init method of AKRInventPieceSum I have found that when coming from
InventOnHandItem the InventSum.InventDimId, and recidId are blank?? Coming
from AKRInvByAttributeOnHand all the fields are OK.

Any Ideas why and/or how to fix this?

Thanks
Abraham Z.

[F van G]

Hi

The InventOnHandItem uses a dynamically generated query for summing etc, and
as such the inventdimid and recid fields might (most likely are) empty. This
might be why your relation does not work in this case.

Post by Abraham Zwygart
I have a form called AKRInventPieceSum. That uses a table with the same
InventOnHandItem (sys level, except a button), AKRInvByAttributeOnHand, they
both call the same menu item passing InventSum table.
If I add a relation to AKRInventPieceSum back to InventSum using ItemId and
InventDimId (to help with linking from InventSum to AKRInventPieceSum), the
from AKRInventPieceSum stops working when called form InventOnHandItem, but
continues to work when called from AKRInvByAttributeOnHand???
In the init method of AKRInventPieceSum I have found that when coming from
InventOnHandItem the InventSum.InventDimId, and recidId are blank?? Coming
from AKRInvByAttributeOnHand all the fields are OK.
Any Ideas why and/or how to fix this?
Thanks
Abraham Z.