Compare two tables

[Ryan Prager]

Is there a way to compare two tables of information in FileMaker and have it report any differences?

Example:

I have two tables of asset tags for inventory purposes (shipping & receiving). I want what is received to be compared somehow with what was shipped. Any ideas?

View this post to see a more detailed explanation.

Inventory Tracking Database

[Jeff Bills]

One, your asset tags must be the same. Create a third table (Inventory Total) with an Asset Tag field and create a relationship between the first two tables' Asset tag to the Asset tag in the third table. Add a calc field to the third table that subracts your shipped product from your received product (and a warning if shipping is greater than receiving . . . ha!)

[Ryan Prager]

Thanks for sample file. The only problem is that each piece of equipment has its own asset tag. We have 250 laptops and each has its own tag.