Charley

Here is the Link. Its not from me, but i have a similar Problem. I guess most developers come to this point sooner or later and the question if there is a efficient technique http://fmforums.com/forum/showpost.php?post/142068/ The Problem is how to set up a hierarchic Bill of materials (BOM) - Charley

Hi all, im kind of beginner (one year in FM8) and now have a bad problem. Here is my real world Problem im trying to solve within filemaker 8: I have an Amplifier made of several PCBs (Printed Circuit Board) Thoses PCBs are build (as u can guess) with lots of single parts. Some Amplifies are build with the same PCBs. They difference between thoses Amplifiers is mostly the amount and type of PCBs. Maybe, you can say, those PCBs can be viewed as Modules. What i like to do is following: 1. When i get an Order i would like to print a list of all Parts i need to produce the Amplifier. So i can give it to an employee, who can get the parts from the dump. 2. I like my Database to inform me how many Amplifies of each type i can build with my current stock. (Can be on Button...) This is for my infomation, when to order... 3. When i write the invoice of an Amplifier, the database should subtract the PCBs and of course the parts from the Stock. Is this possible and how can i do it? Maybe you can help me or give me links (articles, videos etc) where i can learn how to do it? Charley

Hi. I have a simple 3 Table DB. Planning Objects and a Join Table JOIN_plan_obj Those Objects are in fact People. People how won´t come to an event if there is her best Friend (the condition) also invited. To shorten the whole thing an objekt has just 2 fields. Name and Vorraussetzung (condition) What I like to do is: If i choose Someone who has got a Condition Partner, which is not jet in the Join Table,i like to get at least an error massage that i have to invite that Person first. A simple File is attached and Zipped. I think first of all i need to fill in the Condition Fields for the Peoples with their Keys. And then start some kind of Loop. But i cant get it work. helpme.fp7.zip