Recent content by jimmypickins

Hi all, I'm on mobile now so excuse the formatting or typos. One order can have multiple shipments but each shipment only belongs to one order so the relationship is a many to one not a many to many. I thought of doing a shipping header table but I feel I will run into the same situation...

Hi llkhoutx, Both tables do have a primary key, the problem is there is no unique field that I can use to index without duplicates as each order can have multiple shipments. The primary key for the order table is [LineNumber] which is an indexed autonumber. The primary key for the shipment...

Good day, I am trying to build a database to handle a small inventory shipping and receiving. I thought I had everything working, but noticed right at the end that the append query was made incorrectly. This query is only handling what was actually shipped/received off the order as a whole. The...