Joins
You assumptions are correct up until the last paragraph.
I am talking about relationships and across all 6 tables and the QtyMade
table the rows will be equal. I have set them in a one to one relationships
with a left join type (sorry I know you prefer to reserve the word join to
queries but that is how access describes it). And the PK across the 6 tables
are unique from eachother.
The batches/items are not stored in more than one location but I also don't
need to hand onto that information so it is in a separate table so it can be
purged when we no longer have those items on the shelves. That relationship
is also a left one-to-one.
And I have a one-to-many relationship bxt the QtyMade table and the
PackageDetails table, since the batches will be sent out in increments, so to
speak.
So...I think I'm safe. From what I have gathered from your response.
Thanks,
AG
P.S. Could you look at another posting of mine, I need some assistance on
code. Search "Cascading Combo box and additional parameter". Thanks again.
|