Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jairome

  • Rank
  1. Issue #1: Okay... I thought I had it... but now I realize I need something that is a bit more complex. I played around with conditional value lists, and got the Brands to show a list of Add Ons that were related to that Brand only. But that was just a test... What I really wanted was a List of Add Ons that the Owner can select, limited to what is available for each Brand. The problem is, I can't seem to get this portal to work. I thought I should hook up the relationship between my AddOns, AddOnOwner, and Owner, but it wouldn't allow it, saying I need to duplicate one of my
  2. now I'm guessing I have to dig into scripting... How would I create a drop down list that displays values only when certain criteria is met? For instance: If I have Brands, and Car models, and users can choose what kind of add-ons are allowed depending on their Membership Type. If they have a Pro membership, all add-ons are selectable, if they have a Basic account, only some add-ons are available.
  3. Thanks... so far I've been able to expand upon this database and make it slightly more complex thanks to your help. I'll probably get stuck soon enough, but I feel like I'm finally getting my feet wet. Much appreciated. :
  4. Now I'm completely stumped ... I seem to have emulated, on my own, the same steps as you have outlined. But, for some reason, I can't seem to enter data in the portal. It is locked from me using the drop down list, even with a number of Brand records created. Here is the file: Cars.fp7.zip
  5. Thank you... that helps a lot, and has me understanding how Filemaker works much better. That being said, I'm sure I'll have plenty of more questions just around the bend... :
  6. Ok, here it is. I also discovered that every time I add a new brand to the 'Owner' category in the portal, it creates an entirely new 'Brand', even when I choose an existing brand. If I create a new Owner, and add the currently existing brand, 'Honda', it creates a second record of 'Honda' in my Brand table. And the id of the Brands only iterates as I add new Owners, not new car brands, or new records of Brands. Thank you for taking the time to look at this. : Cars.fp7.zip
  7. I must be in the midst of chaos... I have done this successfully... But when I add a new Brand under the portal, it does create a new entry for Brand, which means I can make a list of Brands each person owns... but the ID number doesn't iterate... it simply stays the same value. If I change it, the whole list of brands deletes from the portal.
  8. Thank you, That helped me look into relationships... which has really helped figure this complex program out... Now, the next question, what are id's and how to utilize them? Are they incrementally assigned values based on a calculation?
  9. Hi, I am new to FileMaker, and have been playing around with it for a few hours now. I'm looking to replicate the functionality shown in iTunes smart playlists, in which the user pulls down a behavior from a drop-down list, but can add more. Basically I would like to have an inventory of car enthusiasts. For each person, I would like to let them add multiple cars in their collection. I want to include them by brand, which will be accessed by a drop-down list. But I want to user to be able to add multiple vehicles. So maybe Joe Average has only one vehicle, but Jay Leno has d
  • Create New...

Important Information

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