Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data validation in FileMaker Pro

Status
Not open for further replies.

RareJunk

Programmer
Mar 23, 2010
2
US
Hello Everyone,


I am trying to perform data validation using File Maker Pro. I have two matching layouts, Table1 and Table 2. When someone enters data into Table1, there is no validation involved. I will have a different user entering data into Table 2. At that point, I want it to validate the data against table 1.

So , in table 1, if i have the fields

Field A - primary Key
Field B
Field C
Field D.

and in Table2, i have the fields

Field A - primary key
Field B
Field C
Field D

When they enter data into Table2 for Field B, it should check

Table2.FieldB = Table1.FieldB AND Table2.FieldA = Table1.FieldA

If this does not pass validation, I don't want to save the data.


I dont know if there is another way for data validation...

If there is, please let me know.

I have never used Filemaker Pro and this is my second day ....


Thank you in advance for your time & suggestion. Your help is greatly appreciated!!!

Thanks ...

FMP NewBie :)

 
Sorry. I missed this for while.

Do you have a solution yet?
 
I would set-up a relationship between the 2 tables and use the

then create the validating calculation field

under logical functions you should find...

isvalid(field)

if(isvalid(Table1.FieldB);"blah";"blahblah";)


would be the calculation to set a flag blah when it is valid and blahblah when not.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top