Re: Relational and Validation

Set up a form that is opened in a new window.  Lock the window so it cannot

be closed.  Put an OK and a Cancel button at the bottom.

Then OK will do whatever you want to validate.  Unlock the window and
close 
it if all is as required.

The script to lock a window is ver short and can be used often.

New Window Script
New window Name Input or whatever, size a tad smaller than main window
New record
goto whatevers, do whatever

-------------------

Lock Script
lock and hide status area
allow uer abort[Off}
loop
pause indefinitely
beep
end loop

save as "Lock Window"

then call at the end of new window script

----------

Unlock Script

Close Window (named above)
Commit records
Halt Script

Save as Unlock Window

OK Button
validate and save

Cancel
Delete new record and cleanup


-- 
-------------------------------------------------
Captain Guy
s/v Island Time (Beneteau 352#277)
AICW 845.5
386-689-5088


"Luvin lunch" <martina_mullin@[EMAIL PROTECTED]
> wrote in message 
news:b95d5151-63fd-45dc-894b-3caa972d9d1a@[EMAIL PROTECTED]
> 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