Hi,
I've been reading up on Filemaker but I'm having difficulty
establi****ng the following:
1. Is FileMaker Pro 9 a relational database. I've read that it stores
its data and its table structure seperately and there's something
relational about that but is the data itself normalisable?
2. How would I implement validation on a FileMaker form? I want to
stop any type of data entry before I've had a chance to check that the
data is OK. In the FM 6 database that we used before there was no
validation on the front end of the database. I know you can do a
small amount by setting up data types and using the in-built
vaildation but the validation I'm looking for needs for example to be
able to check if a record already exists or to check that if field one
has a value, field 2 must also have a value. Actually, I suppose I'm
looking for a save button on the bottom of the form that will execute
validation in one go and only if all validation is passed will allow
changes to the underlying data.
If you can offer me any clarity on the questions above I'd be very
grateful.
Regards
LL
