Updating data between FileMaker and Claris Studio data sources

In general, committing data in a Claris Studio data source works the same as committing data in a FileMaker Pro table. For example, FileMaker clients save changes to Claris Studio data when you exit a field or move to another record. For more information, see Committing data in records. However, because Claris Studio data is controlled by different software and can be used interactively by users working in Claris Studio, there are certain actions you can take to ensure you have the latest record data and table schema.

To display the latest data from a Claris Studio data source:

  1. Open the file with the link to your Claris Studio data source.

  2. In Browse mode, choose Records menu > Refresh Window.

    Current data, including data entered by users outside of FileMaker clients, appears. You can also flush the internal cache with the Refresh Window script step.

    For Claris Studio data, FileMaker clients use "optimistic locking" to control data entry. FileMaker clients don't automatically refresh data when you begin entering data in a Claris Studio record or when you do a Find on Claris Studio data.

To sync field schema between a FileMaker and a Claris Studio data source:

  1. If you haven't already signed in with your Claris ID, choose File menu > Sign In to Claris ID, then sign in.

  2. Choose File menu > Manage > Database.

  3. In the Manage Database dialog, click the Fields tab.

  4. Choose the table you want to work with from the Table list.

    FileMaker Pro displays fields from the Claris Studio table. The field names appear in italics.

    If you don't see the table you want from the Claris Studio data source, you need to add it first. See Connecting to external data sources.

  5. Click Sync.

    FileMaker Pro updates the schema between the Claris Studio data source and the "shadow" table. You have not changed the field schema in the data source. You have only updated the FileMaker Pro table schema for any new or missing fields. For example, if you delete a field from a Claris Studio table in the relationships graph, when you click Sync again, the field from the Claris Studio data source will reappear.

Notes 

  • The following errors may appear.

    • This error message

    Displays when

    <No Access>

    A field is removed from the Claris Studio table. This error is displayed in the field object.