Home » Developer & Programmer » Forms » Forms record validations Question. Urgent!. Please hlp.
icon5.gif  Forms record validations Question. Urgent!. Please hlp. [message #120276] Wed, 18 May 2005 12:37 Go to next message
mlgonsalv
Messages: 35
Registered: March 2005
Location: DC
Member
I have two blocks based on a view-A and a table-B with a master detail relationship.
The view A consists of three table joins ( tables-X, Y, Z) and no outer joins.

view-A has all the records and considered as parent table. Block-B has FK relations to view A in the form.

The detail block saves records in Table B in db which has the same columns as table X. But there is no FK relation between Table X and Table B.


Now, my question is, when an user enters records/items on the detail block, how do I validate the records agains Table X which has those same fields but more. I am thinking of when-validate-item trigger also Post trigger. Any suggestions would be greatly appreciated.
Thanks
Michael

Report message to a moderator

Re: Forms record validations Question. Urgent!. Please hlp. [message #120296 is a reply to message #120276] Wed, 18 May 2005 18:37 Go to previous message
danosw
Messages: 20
Registered: May 2005
Location: California
Junior Member

When-validate-item (on the items in the detail_block) or when-validate-record (detail_block)... Also use pre-update and
pre-insert triggers on the detail_block. Which just depends on the type of validations.


Dano

Report message to a moderator

Previous Topic: oracle connection from MFC
Next Topic: Record Group Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 04 13:43:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.