Inventory Master List Help
Closed
Duseyru
Posts
1
Registration date
Sunday July 23, 2017
Status
Member
Last seen
July 23, 2017
-
Jul 23, 2017 at 10:09 PM
Blocked Profile - Jul 24, 2017 at 05:16 PM
Blocked Profile - Jul 24, 2017 at 05:16 PM
Related:
- Inventory Master List Help
- Master royale - Download - Strategy
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Typing master 11 mod apk - Download - Education
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
1 response
Use a Database for this type of operation. A spreadsheet is for calculations, not record keeping!
Go get OPENOFFICE and start a new BASE.
Create a table called MasterInventory:
ID (key)
ItemName (name)
ItemCost (cost)
Create a table called Building:
ID (key)
BuildingName (name)
BuildingRoom (room number)
Create a table called EQLocation:
ID (Key)
ItemID (ID from MasterInventory)
BuildingID (ID from Building, so if ID 1-you would know ID is room 1 of building 1, or what ever you put for KEY 1)
Now, report from EQLocation, and you will get a listing of each item in each room, as you ask for it, as in:
SELECT ID FROM EQLocation WHERE BUILDINGID=1;
Now, you would get all items in EQLocation that was in building 1.
Have fun!
Go get OPENOFFICE and start a new BASE.
Create a table called MasterInventory:
ID (key)
ItemName (name)
ItemCost (cost)
Create a table called Building:
ID (key)
BuildingName (name)
BuildingRoom (room number)
Create a table called EQLocation:
ID (Key)
ItemID (ID from MasterInventory)
BuildingID (ID from Building, so if ID 1-you would know ID is room 1 of building 1, or what ever you put for KEY 1)
Now, report from EQLocation, and you will get a listing of each item in each room, as you ask for it, as in:
SELECT ID FROM EQLocation WHERE BUILDINGID=1;
Now, you would get all items in EQLocation that was in building 1.
Have fun!
