Jump to content

script or look up field?


This topic is 7883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have 352 entries in a FM file for a photo contest I ran in 2000, most of which will be entering again this year. I have been trying to figure out how to set up this years FM file so it can look up the

information(address, phone, etc) from last year after I enter the name. I cloned last years file with no records and set up the desired relational fields but that doesn't seem to do what I want it to. Do I need to write a script to do that? Please help.

Link to comment
Share on other sites

  • Newbies

Thanks for your response. I set up the relationships for the name, address, phone etc between both files but I haven't set up look ups yet because I wasn't sure how to do that. The way it is now the data is automatically put in the new file. I want to be able to start with a blank entry form, type in the name and have FMP fill in the address, phone, etc from last years file.

Link to comment
Share on other sites

First, you shouldn't need multiple relationships. In each file you will need an "Entry" number field. In the old file this can be created and give a sequential number for each record. In the new, empty file create a relationship to the old file with EntryNo. matching EntryNo. In the new file, give EntryNo. a drop down value list based upon the fields EntryNo. and (as a second field) LastName (or phone number or address). The second field gives you something to use in selecting the correct EntryNo. (these EntryNo.s are otherwise pretty meaningless to the human).

Now, define all of the contact fields in the new file as lookups of the matching fields in the old file based upon the EntryNo.<=> EntryNo. relationship.

How it works: When you create a new record this year, click on the drop down field for entry number and select the correct Last Name (or phone number or address, etc.). This selection will enter an EntryNo. which will drive a lookup to the old file and bring across all the old information into the fields you have defined as lookups.

-bd

Link to comment
Share on other sites

This topic is 7883 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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