What version of FileMaker are you using? The starter solutions for versions 11 and 12 are quite different, so I need to know the version before I suggest a full answer.
i need to be able to have on thatrecord the option to have small medium large and extra large of the same product - and each size to have a diffrent stock level
I strongly suggest you have separate records for each product's size. Trying to track stock levels for each size for a given product from a single product record will be very difficult.
im using 12 pro thanks mate
Each starter solution is a separate, independent solution that does not share data with any of the others. I think you can find and download a merged version produced by the same folks that set these up for Filemaker Inc., but I don't know the link for it...
Take a look at the Inventory starter solution and study how the Stock Transactions log works. If you receive a shipment of 20 "acme widgits", you create a new record in this table, put 20 in the "units In" field and Select "acme widgits" from a drop down. If you sell 5, you create a new record and put 5 in the Items Out field with "acme widgits" selected.
Here's the key thougth I am headed towards: You can modify the InvoiceData table in Invoices (what we used to call the "line Items" table), to also serve as your stock transactions table. The Qty field in InvoiceData can serve the same purpose as "Units Out" in Stock Transactions in the other file. You can then add a field for "Units In" and set up an additional layout based on Invoice Data for logging any non-sales stock transactions. When Items are sold, they will automatically appear on this new layout without the need to enter them twice.
Additional fields you can add to InvoiceData:
cBal (Units In - Qty )
sBalanceRunning (Summary, Total of cBal, restart totals when grouped by ITEM ID MATCH FIELD)
sBalance (Summary, total of cBal)
You can then set up that new layout to look like a typical bookkeeping ledger where you can both log new stock transactions and (if you keep your records sorted by Item Itd), also see both the current inventory levels for each item and how these levels change over time. This allows you to adjust the frequency and quantities of your restocking orders such as increasing the rate/qty re-ordered for an item that you notice has a stock level that is frequently close to zero.
okay thanks very much - but on the filmaker pro 12 in the invoice template it has a part for products - where you put in quantities and info - surely theres a way to do what i was asking about if the template does invoices and products?