AnsweredAssumed Answered

Semi-Newbie: Anchor Bouy - Related Field Displaying Incorrectly on one TO

Question asked by hartsough18 on Mar 8, 2017
Latest reply on Mar 9, 2017 by Jason Wood

Hello,

 

I have been studying FileMaker for around a month now and am having trouble setting up the Database I want to create. I discovered Anchor Bouy Method last week and have been trying to implement it.  I believe I am close to designing a successful Anchor-Bouy based RG but I am caught up on a snag involving one of my 3 Tables inconsistently displaying a related field. Details below:

 

I have 3 Tables: Inventory Items , Locations , and Inventory Assignments

 

 

The goal is to track inventory by assigning every Inventory Item to a Location. Each Inventory Item will be assigned to one Location at a time.

Below is my RG:

FileMakerCommnuity-01.png

 

The issue occurs when I try to view Locations from the Inventory Items Table.  For some reason, only the Inventory Items that have a Lavner Number(non-unique Company number) of "001" display what location it is assigned to. *Note: the Lavner Number field is not related to anything!

Image below:

FileMakerCommnuity-02.png

 

However, when viewing the assigned items from the Locations table, everything shows up, not just the Inventory Items assigned with a Lavner Number of "001". Shown below:

FileMakerCommnuity-03.png

Just for further clarity, I have attached an image of all the Inventory Assignments, shown below:

FileMakerCommnuity-04.png

 

CONCLUSION:  When trying to view Locations from the Inventory Items table, only Inventory Items with the Lavner Number "001" show a Location.

 

Any help or guidance in general is appreciated.

 

Thank you!

Outcomes