AnsweredAssumed Answered

Equipment Inventory Database

Question asked by psbajohr on Feb 4, 2010
Latest reply on Feb 4, 2010 by ninja

Title

Equipment Inventory Database

Post

Hello,

 

I am trying to create a basic serialized inventory (equipment is serialized already) for some equipment we use at our office.

 

Basically for now, I would like to create a main splash screen, with two buttons, each button linking to a respective serialized inventory when clicked.

 

I have so far created a table called "inventory", a second table called "item A on hand" and a third table called "item B on hand"

 

Within the item tables, I have a "type" field and an "expiration date" field.

 

My main goal is to ultimately keep track of the equipment, and also have a total box in each item's list, so I can know when to reorder, etc.  I just cant seem to figure out what relationships I need and also how to link the buttons, etc.

 

I am using filemaker 10, win xp.  I am fairly new to filemaker and am looking to have this database available to a slect group of users via network once completed.

 

Thanks so much in advance!

Paul

Outcomes