Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About zibzab

  • Rank
  1. Hi, I’d like to have some value lists that are based on a previously selected value. ie. Car Manufacturer (Select Audi from value List) Model (A6 Avant) This is selected from a list of models unique to Audi. Engine Size (3.0tdi) Again this is based on the fact that the previous selections have narrowed the engine options down to those only available on an Audi A6. Does anyone know how to achieve this type of value list in filemaker. I tried to do it on found sets but no luck so far.
  2. Sorted it – would have helped if I had put the correct field names into the Script Parameters! Doh!
  3. I’m trying to limit the number of scripts I have by using script variables which are great. I have an issue at the moment though which maybe someone can help me with. My script parameters are two field names (ie: Table::Fieldname). These are then defined as variables in a script (ie Set Variable to $$fieldname1 = GetValue ( Get (ScriptParameter); 1). This part works fine, it sets the script parameter as a variable. What I then want to do is set another variable from the contents of the field which was defined as a variable from the Script Parameter above. So I set my field contents
  4. Hi, thanks for all your help. I think I have enough to work with.
  5. Hi RodSierra, thanks your advice – do you have an example of a good bill of materials structure to point me in the right direction.
  6. The article sort of mentions it. The Gould Water Pump has the screw and silicone gasket as components of it, and it (the water pump) is a component the Engine. This child / parent thing is reasonably easy to do – some of the scripts mentioned in the article are hard to follow though! However, his model will show the above in 2 portals (one for parent and one for child relationships). What it wouldn’t show though (when viewing the Gould Water Pump record) is that the Engine belongs to the Ford Mustang (for example).
  7. Its amazing how the diagram looks simple, but it’s actually really complex!!!
  8. Hi, in all honesty I have never made an official ERD. I think this this is what you are after. I have one main table and then a join table. This is a Many to Many relationship based on Jonathan Stark’s model on recursive data structures.
  9. Hi, I’ve uploaded a diagram of the relationships. I have used a list, but i need to have the ability to navigate to any of those records from within a portal, and my experience of lists would suggest that the list is static rather than dynamic (I could be using the wrong terminology there). I’ll check out the threads you mention – thanks again for your help.
  10. I have created a sort of work around to this – but it is not great. Basically a new portal for each generation down the line for parents and children. This is a bit clumsy especially when relationships might go up or down 10 + levels. Now that it is possible to view all generations (in separate portals), do you know a way of getting them to view in one?
  11. Hi bcooney, thanks for that thread – very helpful. I can now get an individual component to show each workflow it is connected to, or what other components it might use. However, this only goes to one generation (parent and children). I can’t view in the portal relationships beyond that. ie. My workflow is wf1 and it uses comp1, comp2 and wf2. wf1 is also used by wf3. What I can’t see is the components that wf2 uses and also the fact that wf3 is used by wf4. Do you know anyway of displaying these descendants / ancestors of a relationship in a portal. Thanks for
  12. Hi, yes it does appear to be complicated – thanks for answering. I have been trawling through the forums for the last 3 days and found an example which sort of does what I want by using a single table with self joins. The problem with this however is that I can only view the links one way. For example, if workflow B uses workflow A as part of it, I can see a list of components (comp a, b & c) used in workflow A within workflow B via a portal. However, what I am struggling to display is a reverse of that chain. ie, if I go to the comp a record, I can see that it is used in w
  13. Hi, I’m having difficulties creating a database to catalog workflows. I’ll try and explain. The workflows are made up of various components (these individual components are in 1 table). The workflow is then in another table and the components are added via a join table and viewed in a portal. This way we can see all the individual elements that make the workflow. Also in the components layout there is a portal listing all the workflows the component is used in. This is important so that I can see the possible knock on effects of changing any one component. The problem is, that a work
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.