FileMaker9 and SQL server 2000

[aria]

Hi All,

New to FileMaker Pro9, and in the process of evaluating it.

To start evaluating FileMaker we have few requirements

1. To do live connection streaming insert and update records to our backend database that is SQL server 2000 and soon 2008.

2. To do the record validation:

As an example: Using FileMaker forms users create and insert a new record into the backend Database, then for the second time users open the same form and create retype the same record and then compare the second record field by field with the first record and if any filed does not match, then FileMaker informs users about the unmatched field via popup dialog.

3. We will be creating around 300 to 350 questioners forms in FileMaker Pro 9.

Thanks in advance for any constrictive help and advice,

Regards,

Abrahim

[pmconaway]

I don't really have an answer for the live streaming to SQL server but the validation portion is definitely doable in Filemaker.

The way I would go about designing the solution would be to get the validation portion working using filemaker as the source of the data. Then work in the SQL portion. Because your not going to want to insert or delete a record in the SQL database until it has passed all validations. So a least temporary the data has to be stored in the FMP database.

[aria]

Hi there,

The data owner wants the validation portion to be in the SQL database as long as it takes, then using some sword of temp form doing the last validation. So, does such setup works with FileMaker Pro9?

If yes, then would it be possible to do the field by field validation between the temp and main record?

Thanks in advance,

A

[pmconaway]

You can set validation on a field. Look in the database field definitions. There are some settings there. They are listed in the field options.