AnsweredAssumed Answered

creating inventory and order database from product list

Question asked by TimRogers on Oct 24, 2010
Latest reply on Oct 25, 2010 by philmodjunk

Title

creating inventory and order database from product list

Post

first my apologies if this is in here somewhere. but I am just newto filemaker, am learning it and am using it for my business....which is a bar. so, i've created a liquor inventory list that, basically, looks like:

PRODUCT NAME | PRODUCT ID NUMBER | PRICE
========================================
product name 1   | 1234                              | $19.99
------------------------------------------------------------------------
product name 2   | 4567                              | $21.99
------------------------------------------------------------------------
etc...

i want to use my list of productsto create both inventory and prder lists that are also stored as a database... so....inventory databasewould like:

DATE      | PRODUCT NAME 1 | PRODUCT NAME 2 | ETC....
===========================================
January   | 5                             | 7                              | ...
-----------------------------------------------------------------------------
February | 8                             | 3                              | ...
-----------------------------------------------------------------------------
etc...

Am I making any sense? Is this doable?

Anyone's help would be greatly appreciated. Thanks

Outcomes