Ok, first things first. I really love this product!!
I am probably asking a question that has been asked 100 times, but I have not found an answer that is final or that is definitive.
I have database that I cannot alter and the design is such that the relationships are something I am having trouble getting to work.
I can give a pseudo relationship and maybe someone can tell me what I might do to get this working.
I have really 5 to 6 tables involved.
Primary Key is ItemKey
WarehouseBin – Bins
Primary Key is WhseBinKey
WarehouseBinInventory Items and their quantities in a given bin.
Primary Key is ItemKey, WhseBinKey
References are ItemKey to Item, WhseBinKey to WarehouseBin
ItemLot – Lot Numbers and expriation dates for given item
Primary Key is InvtLotKey
References are ItemKey to Item
PrimaryKey is InvtLotBinKey
Reference is to ItemLot on InvtLotKey and WarehouseBin on WhseBinKey
What i am trying to do is to take an Item and show WarehouseBinInventory with a parent Reference to a WarehouseBin and a child reference to WarehouseBinInventory.
|_ WarehouseBinInventory - WarehouseBin
|_ItemLotBinInventory - ItemLot
I just cannot figure out the .Join syntax. Can someone help me or tell me it can’t be done.
Yes I know I could come up with a view that would work, would rather make it work with a direct reference to a Table if possible.
Thanks for the help.