Currently I'm working on a data base that tracks inventory for clients.

I am using 4 tables
- Client Info (primary key Client Name and Client ID)
- Inventory (primary Key Crate number)
- History (Primary Key HID auto number)
- Crate Contents (Primary Key CID auto number)

Each client has several crates and they can't be duplicated, but crate numbers can be duplicated if used by a different clients.

Is there a way to do this?
--
Thanks,
Jodie