Customer - OBJECT
[CustomerID, NameLast, NameFirst, Address01, AddressCity, etc]
Technician - OBJECT
[TecnicianID, NameLast, NameFirst, Address01, AddressCity, etc]
Parts - OBJECT
[PartID, PartName, PartSerial, PartColor, PartPrice, etc]
Invoice - PAPERWORK
[InvoiceCustomerID, InvoiceNumber, InvoiceDate, etc]
-< InoiceLineItem - Paperwork ELEMENT
[InvLineItemID, InvLineItemPartID, etc]
Transfer - ACTION
The White Paper for FMP Novices is useful and gives examples of normaliztion
Lynda dot com has Filemaker Videos (portions are free)
Free unlocked templates are useful for examining design
Starting Point -
A free calendar is available to be bolted onto your database
You can search specific Filemaker sites on this Custom Google Search
Looking at FMP business database demos is useful - some are fully useable
The Excelisys Business Tracker V3.0
Not sure i followed. Still trying to get the whole relationship and table thing down. Here is my idea of how the db should work.
I have over 100 parts to add to my inventory list. Each day (date important) I can have any of 3 types of transactions take place.
First kind is to sell a part or multiple parts to a customer,
Second is to transfer a part or multiple parts to another technician,
Third is to Replenish stock by ordering a part or multiple parts.
I would like the db to record every transaction for that part used by order of date on each of the parts individual info page so i can have a history of all transactions that occurde for that given part.
Based on this i have my 5 tables.
1) INVENTORY (Parent to Part transfer, Store, Stock Replenishment)
2) PART TRANSFER (Child of Inventory)
3)STORE (Child of Inventory, Parent to Store Invoice)
4)STORE INVOICE (Child of Store)
5)STOCK REPLENISHMENT (Child of Inventory)
Now, Each part can have multiple Quantities used for any given transaction. And each transaction can have multiple listed parts. How do i show a seperate line for each part used and quantity used for each transaction. How do i link that to my original Inventory Db that will show history of all transactions for each part. Does it make sense?
Here is what i came up with. Would this work?
You may find it useful to enter "Inventory Ledger" into the Search the Forum box at the top of this screen to find other threads that discuss inventory control via Filemaker.