I am at a dead end. I am creating an inventory database for my work with over 14,000 items. We have about 600 MacBooks each going into one of 24 rolling carts. The carts as well as the laptops are entered into inventory. I am trying to figure out the best way to handle these "groups" of items. I would really like to just check out the cart, and that checks out all the computers assigned to that cart. Any thoughts or ideas is greatly appreciate!
The tables I have are Assets and Employees, with fields in the Assets table being AssetID, Checked Out To, and Parent Tag. if that helps any...