AnsweredAssumed Answered

Creating new record in a second file

Question asked by ValerieFusco on Oct 18, 2010
Latest reply on Oct 19, 2010 by philmodjunk

Title

Creating new record in a second file

Post

Hi - Thanks in advance to anyone who can help with this. I am a beginner level FileMaker programmer who has been asked to solve this problem:

There is an existing filemaker system with a database containing customer information. The company is starting a second, related business, and needs to keep the data from the second business in a separate file. Some customers for the second business will be customers from the first business; other customers will be new.

A couple of questions:

  1. I can set up the new file, but am confused as to whether the tables are "related" in the Filemaker world. There will be similar fields (name, address), but many of the records in the new table have no corresponding records in the old table. I have created table occurrences in each of the files, but haven't created any relationships.
  2. I am trying to write a script in the old table that will create a new record in the new file, and then copy some of the information from the old file. The script doesn't work in the way I intended - it opens the new file, but creates a blank record in the old file. What am I doing wrong?

Set Variable ($$name; Value":BusinessOne::BusinessOneName)

Open File ("BusinessTwo")

New Record/Request

Set Field [BusinessTwo::BusinessTwoName; $$name]

Commit Records/Requests[]

As I said, I am a novice at this and would appreciate help from anyone who has the patience to walk me through the problem! Thanks

Outcomes