Hi,
First, I'm really not an expert with Filemaker and I'm not familiar with this forum. Hence, I'm not sure that this is the right place to post...
Here is my problem and I would highly appreciate your input: I want to build a database for inventory and management of cells that are stored in liquid nitrogen. They are in tubes that are placed in kinds of drawers (triangular ones). In one tank, we have 6 stacks of 6 drawers, each drawer containing 60 tubes. At first glance, my problem seems easy and each entry of My Db could contain the coordinate of each tube:
Container-Stack-Drawer-Position (in the triangle)
However, the triangular shape of the drawers makes the coordinate quite error prone. What I would like to do is to have a schematic representation of each drawer. At once, one could detect empty and filled position in the drawer. By clicking on a position, one could access to the record of the material that is stored in this tube. How should I build my Db for this goal? Many many thanks in advance for any help!!