6 Replies Latest reply on May 10, 2011 3:38 AM by james.gould

    look if there are related records



      look if there are related records


      Hi all,

      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?