The White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Filemaker Wikipedia -
Filemaker - Version By Version -
Lynda dot com has Filemaker Videos (portions are free)
Free unlocked templates are useful for examining design
Starting Point -
RCC Blog -
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 -
Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
Google "Campus Productivity Kit"
I recall our earlier discussions, but not the details. Are you trying to modify that original design or start over from a blank page here?
If you want to modify the current design, you'll need to post a description of it and how it works for you. There are several variations possible on how you might handle "kit" sales.
Then you'll need to describe exactly what you want in terms of this "products kits list display". A list of all products in your inventory? All the kits? All the kits and/or products sold to customers? or ???
Not sure whats best to do as i have some of the database invoice and products ,customer and it may be best to start again i have beed trying to add the kits for some time but not sure the best way to do this as i would like to add the kit details to the invoice and have a single price
The kit will be a few that we can use over and over again and then there will be ones for just that towbar
eg standard kit 1 plug or 2 plug and now 13pin plug
eg interfacer kit 1 plug or 2 plug and now 13pin plug
eg dedciated kit 7 pin or 13 pin
Hope this help any thing more just ask
thanks for you help
Unfortunately, your screen shot is a bit too fuzzy to read and it won't let me zoom in for a closer view.
A script can add in the items that make up the kit as separate line items just beneath the kit entry--but with a zero unit price. A number of different tricks can be used to produce a viaual grouping effect such as indenting the kit items a few characters so that it easier to tell that these added items are part of the kit entry listed just above them.
Is this the structure to your database tables?
Invoices::InvoiceId = LineItems::InvoiceID
Products::ProductID = LineItems::ProductID
Products::ProductID = KitItems::KitProductID
KitProducts::ProductID = KitItems::ItemProductID
and KitProducts, Products are both occurrences of the same data source table.
yes kitproducts ,products are both the same data source table
Consider this script, performed by an onObjectSave trigger on the LineItems::ProductID field:
If [ Not Isempty ( KitItems::kitProductID ) // this is a kit ]
# pull up list of kit item records
Set variable [$KitQty ; LineItems::Qty ]
Set variable $InvID ; LineItems::InvoiceID]
Go To Related Record [Show only related records; From table: KitItems; Using layout: "KitItems" (KitItems)]
#Loop through the kit items and create one line item entry for each item that makes up the selected kit
Set variable [$ProdID ; value: KitItems::ItemProductID]
Set variable [$Qty ; value: $KitQty * KitItems::Qty //this step allows you to have more than one of the same item in a kit]
Go to Layout [LineItems (LIneItems)]
Set field [LineItems::InvoiceID ; $InvID //link it to current invoice]
Set Field [LineItems::ProductID ; $ProdID ]
Set Field [LineItems::KitFlag ; True ]
Set Field [LineItems::Qty ; $Qty]
Set Field [LineItems::UnitPrice ; 0 ]
Go To Layout [KitItems ( KitItems ) ]
Go to Record/Request/page [next ; exit after last]
Go to Layout [original layout]
KitFlag can be used with conditional formatting and/or calculation fields to make the listed items that make up the kit appear distinct from items that are not listed as part of the kit.