Implementing Foreign Key Constraints

[Michael Reade]

Does anyone know what is the best way to do that?

Thanks,

Michael

[Lee Smith]

I moved your question to Relationships from General Discussions » FileMaker Product Family » FileMaker 8 and 8.5, because this seems to fit your topic better, and the General Discussions are for questions about the products, not the Functions and Features.

Your description of what you need isn't clear, and needs to be expanded. From you descriptions, it sound like you are wanting to filter your relationship, maybe..?

Lee

[corn]

There are several ways of implementing foreign key constraints.

The first constraint you might want to implement is existence. This is performed throught the field validation options. Create a value list based on the primary key of the related table, and validate the foreign key for membership in the value list.

When the primary record is deleted you may want to delete any related records (cascade delete ) - this is enforced through the relationship graph.

Other constraints, such as what happens when the primary key is modified, are beyond FMP's native toolset. Using a script-triggering plug-in (there are several free and commercial variants available) you can enforce different integrity constraint rules, including blanking foreign keys when the corresponding primary is deleted and propogating changes in the primary key to all instances of the foreign key.

Hopefully this gives you some place to start.

[Coolbdy]

Hi,

i also want to implement relationships in File Maker database.

(Programmatically using query and with FM ODBC driver 11.03.81.00)

but i m not able to do this. i applied only primary key.

how i apply foreign Key (Relationship in filemaker) using ODBC.

plz help me about this to struck at right place.

Is there another method for do this(Any SDK or API).

Have a nice day to you.