look if there are related records
I'm using fmp 11 to create a stock db.
My situation is:
In the warehouse there are many locations, in each location can be put one articles, the article table is linked to the location table with the location code.
In the location table is a field indicating if the location is full or is empty, no other possibilities.
How I can see if the location i full or empty and keep updated on every production order?