OraFAQ Forum: Forms » Referential intergiry in forms

Home » Developer & Programmer » Forms » Referential intergiry in forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Referential intergiry in forms [message #142032]

Thu, 13 October 2005 04:30

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Hi,

I have two custom tables A & B. Both of these tables have a column called "Cust_ID" which doesnt have any constraints associated with it.
I would like to know is it possible to create a reference for these tables in forms (without using constraints).

Thanks
Safeeq

Report message to a moderator

Re: Referential intergiry in forms [message #142058 is a reply to message #142032]

Thu, 13 October 2005 06:15

kiran
Messages: 503
Registered: July 2000

Senior Member

I think you can achieve this by keeping Master-Detail relationship across the blocks.

--Kiran.

Report message to a moderator

Re: Referential intergiry in forms [message #142218 is a reply to message #142058]

Thu, 13 October 2005 18:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you have a one-to-one relationship then, other than the question of why don't you put all the data into one table, you can quite easily create an updateable view that covers both tables. Then base your block on that view and work with both tables at the same time.

David

Report message to a moderator

Previous Topic:	How to query SQL in a block?
Next Topic:	Paper Tray Selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 13:43:22 CST 2025