Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4

Thread: Multikey Lookup

  1. #1
    FREE Member hardline's Avatar
    Join Date
    Jun 2006
    Posts
    58
    Downloads
    0
    Uploads
    0

    Multikey Lookup

    I have an invoice/line items system set up, and at the recommendation of kjoe (thanks!), I changed the price to a lookup so that my invoices won't be affected if the prices of my products change.

    However, each product pulls a list of potential product options from a separate table and displays them as a checkbox; do I need a different field to lookup the price of each product option, or can I lookup all of the prices from the single field with multiple options selected? How would I do it?

    Thanks in advance!
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,012
    Location
    netherlands
    FileMaker Version
    FM 10 Developer, FM 10 Server, FM 11, FM 11 Developer, FM 11 Server, FM 12, FM 12 Developer, FM 12 Server, Older Versions 2-8
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Multikey Lookup

    Hi Hardline

    I remember you bringing up the same issue
    here

    It may be possible to do add the option's price additions and bonusses using a multikey; assuming the options are stored in an options table:

    instead of a lookup, an auto- enter calc (replace existing):
    sum(OptionsTable::OptionPrice)

    however this is less robust than a lookup. If the price is updated, it will not update in the line item. But if an new option is selected after a price update, formerly selected options will update their price as well.
    Their may be other issues, but this is what my test turned up.

    Perhaps it's advisable to at least look into another setup to select options. take a look at the
    duoportals sample by CobaltSky.

    kjoe
    Stick to what you don't know.

    http://www.maartenwitberg.nl


    -------

  3. #3
    FREE Member hardline's Avatar
    Join Date
    Jun 2006
    Posts
    58
    Downloads
    0
    Uploads
    0

    Re: Multikey Lookup

    Thanks for the response, kjoe. I'm not really sure how I would use the duoportals in this case. I think the best solution (at least for now) is the auto-enter calc. I had my line item totals as unstored calcs, and at least this way it will save the information unless someone edits the line item.

    Thanks again!

  4. #4
    Senior Moderator - FMT Preferred Developer Consultant - Netherlands, Europe, Asia, USA Maarten Witberg's Avatar
    Join Date
    Mar 2004
    Posts
    6,012
    Location
    netherlands
    FileMaker Version
    FM 10 Developer, FM 10 Server, FM 11, FM 11 Developer, FM 11 Server, FM 12, FM 12 Developer, FM 12 Server, Older Versions 2-8
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Multikey Lookup

    What I thought: say the main table is your subscriber. The left portal shows his subscriptions. The right one, the options per subscription.
    but I admit it takes some work to set it up.

    kjoe
    Stick to what you don't know.

    http://www.maartenwitberg.nl


    -------

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with MultiKey Relationship
    By moondowg in forum Portal & Relationships
    Replies: 1
    Last Post: 06-15-2009, 04:47 AM
  2. Multikey Syntax
    By dante_in_calgary in forum FileMaker Pro 10 Advanced
    Replies: 2
    Last Post: 04-16-2009, 03:58 PM
  3. Help with Multikey Values
    By Schizo75 in forum FileMaker Pro 9
    Replies: 7
    Last Post: 02-27-2009, 04:11 PM
  4. Multikey
    By FMBNewbie in forum FileMaker Pro Versions 5 & 6
    Replies: 1
    Last Post: 01-08-2005, 10:39 PM
  5. replacing a multikey
    By Maarten Witberg in forum ScriptMaker and Scripting
    Replies: 2
    Last Post: 09-17-2004, 01:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.