Relationships Help

[samp94]

Hi I would really appreciate some help on this as i am very new to FileMaker.

I am building upon the one of the free business productivity solutions and have become stuck trying to add features.

What i need is a database where i can keep track of nuts and bolts which will then be made up into packets. I would ideally then be able to say go in and say that i want to make "5 of packet X" and it would subtract the items needed from the database and add 5 of the packet into the inventory.

I have attached what i have achieved so far and would appreciate it if someone could give me a hand here.

Database.zip

[bcooney]

What you describe is a Recursive Data Structure, and is fairly advanced to build. I hope that Soren chimes in, as he and I have posted about such solutions before.

I usually point people to Jonathan Stark's article, Recursive Data Structures.

This may be quite advanced for a beginner.

Try a search for Inventory on the forum, as well.

[Søren Dyhr]

Hi I would really appreciate some help on this as i am very new to FileMaker.

I would agree with Barbara, that It ideally indeed is a recursive structure, but Don Wieland have made a "cheat" which IMHO makes more sense to a newbe:

http://www.dwdataconcepts.com/dl/tw/compinv2.ZIP

--sd

[samp94]

Following Barbara's advice to search for an inventory i found a link by Søren to an inventory on jonathan starks website that looks as if it would fit my needs very well

http://www.jonathanstark.com/downloads.php#inventory_example

I can now see how complex what i was trying to do was

Please could someone try to integrate that inventory into what i already have it would be greatly appreciated.

Edited October 31, 2008 by Guest

[bcooney]

That's the same link I gave you in my post above. All roads lead to Rome, huh?

Well, maybe it's time to hire a professional?

[samp94]

I have used the Inventory template from jonathanstark.com and would like some help on how to integrate pricing into the database. I need to be able to set a cost price for each child product and then have a calculation to find the cost of the parent product, aswell as the ability to set a retail price for each product. I would really appreciate some help on this.

I have attached my current database

Inventory.zip

[Søren Dyhr]

I don't think that any of the developers here, have made a habit of tweaking of other developers templates as their job. We use approaches from templates we build new solutions from scratch ... based on thorough examination of context and purpose from case to case.

The entire Ryan Rosenberg (Filemaker Vice President) approach to buttering the purchase decision by including a series of ready to use templates, have unfortunately a incitement to prevent a genuine understanding of the theoretically foundations it build upon. Do never use a template "as is"!!!

Unwillingness to tear templates apart for investigation/ understanding and instead use them as blackbox buildingblocks, might give street credit from symbolic analyst to symbolic analyst, but has very little to do with proper development of databases. Stop piggybacking!

--sd