Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Copy field info from 1 table to other

    Hello, I new to the FilePro db software and am having a frustrating time trying to have information copied. Any help would be greatly appreciated!
    I'm using the "Event Planning" template in FileMake Pro 7, and have added 2 fields. The first is a unique serial number, the second is field labeled "Participant" that has 3 radio buttons to categorize the person's information as either, "Sponsor, Vendor or Volunteer".
    I have a separate table labeled "Vendor Information", and am trying to have the Vendor Info table recognize the unique serial number from Event Planning, then copy the name, phone number and notes into Vendor Info (when the radio button checked = Vendor).

    Create relationship, run a lookup, then script? Or....??! I've tried several things, but I cannot get any of the info to show up on the Vendor Info table (not even the serial number).

    Many thanks to ANYONE who can help me!

  2. #2
    Join Date
    Sep 2003
    San Diego
    Create a relationchip between the two tables based on Serial No. and then have the fields from Vendor Info table, directly on the Event Planning layout, so the vendor information you fill in will actually be saved in Vendor Info table itself.

  3. #3
    Join Date
    Feb 2005
    what about if the tables are from 2 different fmp databases
    can it be done

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts