Enforce Referential Integrity (RI) in 1-many

[Leb i Sol]

Hello Everyone!

I have a pretty good feeling about the answer being "NO" but I just wanted to double check with more experienced develpers.

Does the Filemaker automatically enforce Referential Integrity between the related files?

in FM words:

1------->many relationship

FileA--->FileB

autoID-->number

How to(NOT scritped):

If I create a record in FileA and want to "force user" to enter something in the portal (create a related record in FileB) before being able to continue?

Many thanx for your thoughts!

[Kurt Knippel]

Well Filemaker will NOT force this automatically. Nor does this have anything to do with Referential Integrity (which is where the app would automatically update all child records if the ID in the parent were to change).

What I would do is to simply script this so that it is automatic.

[Leb i Sol]

Hi Capthurt!

Thanx for the info, I kinda figured that it must be a the case but I thought it is better to ask

Thanx again!