Jump to content
Sign in to follow this  
rickshaw

updating database

Recommended Posts

I have two files: one large master file with names and addresses (112,000 records) and a smaller file (450 records of a special interest subgroup created some time ago) with some of the names from the master file but out of date addresses. How do I get the new addresses into the smaller database? Basically I want to update my smaller data base with new addresses. The FMP manual is driving me crazy. Anybody willing to help a newbie?

Share this post


Link to post
Share on other sites

If, as you say, the records in the second file are a sub-group of the main file, then here are some alternatives you should consider:

1. Simply create a 'flag' field in the main file which indicates membership of the sub-group, and do a 'find' in the main file whenever you want to view or print records for the sub group, or

2. Create a uniqie identifying key field (eg serial number) in both files and a relationship from the sub-group file to the main file (matching the unique key fields in the two files). Then use related fields from the main file in place of the name and address fields within the sub-file.

In either case, your sub-file will then always mirror the current data in the main file.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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