I was thinking that I might have to do that. I do not currently have both tables linked to a 3rd table. The Device tables *is* linked to another one, but that's for a different purpose. The Allocation table is not linked to anything at this time. The one table that shows the devices allocated just has the Department Name, Contact Person, Device Name Example (this shows anyone creating a new device how to name it), and the Number of Devices they should have. The other table is a list of every device, Serial Numbers (2 different kinds), Asset Tag number, Device Name, Hardware Address, Location, Last Seen, and 22 more fields that don't really mean anything for this purpose. I'm thinking that I would have to create the 3rd table (AllocatedVsActual) that is linked to the Allocation table's Department Name and Device Name Example, and create a formula that links to the Device List table to count the number of devices with a similar name. Then, I guess I would create a report that will show both sets of numbers on the from the AllocatedVsActual table on the dashboard?
