I am way over my head on this one. I am using a database to track cable reels. Reel numbers are assigned upon receipt into inventory. The reel can be issued out or transfered to a different faciltity and then brought back into inventory. On the receiving form I would like to check to make sure the reel status is active and the reel number has not already assigned to an existing stock number. I am open to any and all suggestions. Thanks in advance for your input and recommendations.
Thanks, Dave
Thanks, Dave
