Creating new records

[Bill Jaynes]

I have two db FM5/w98 with contact info. The master file uses a calculation match field which concatenates first and last name. The related file uses a concatenation of it's first and last name fields.They are set to create new records from the master file. When I enter first and last names in the master file and attempt to enter related field data such as a phone number, an error dialog appears saying the relationship is not valid. I realize pairing two calcs might be asking a little much.

Other files that use more conventional matches are allowing record creation with the expected ease.

Thanks,

Bill

[Vaughan]

I discovered this problem myself just a couple of days ago. The problem is that in the *related* file, the match field is a calculation. When FMP tries to make a new related record it inserts a value into the match field, but it cannot because it is a calculation field. Hence the error message.

The only solution is to redesign the data structure so the match field in the related file is a text field.

[Bill Jaynes]

Thanks Vaughan,

I've been hung out by this snag for far too long. I appreciate

your help.

Bill

[signal]

Write a little script which creates a new record in the other database and inserts the desired parts of the calculation (first and last name) with a global match. Now you can insert the other data in your portal and all it takes is the click of a buttonto run the script.