OraFAQ Forum: Forms » MultiBlocks

Home » Developer & Programmer » Forms » MultiBlocks

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

MultiBlocks [message #164902]

Mon, 27 March 2006 07:35

lailakhalid
Messages: 7
Registered: March 2006
Location: LUTON

Junior Member

I've got 2 data blocks (User Info and incident details). The user ID field has LOV set up so you can search for a previous user details and it will insert the details automatically.

So I complete the incident form and when I select the save button its states that you have violated the USER_ID (Pk) field because its been used previously before.

Now I don’t know what would be the best option of setting this up. I need a way of only saving the incident form not the user form. Is there an alternative option?

Report message to a moderator

Re: MultiBlocks [message #165005 is a reply to message #164902]

Tue, 28 March 2006 00:14

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

Senior Member
Account Moderator

You are populating a field when it is not necessary. Please search this forum for 'master detail'. This problem has been explained recently.

David

Report message to a moderator

Re: MultiBlocks [message #165028 is a reply to message #164902]

Tue, 28 March 2006 01:48

lailakhalid
Messages: 7
Registered: March 2006
Location: LUTON

Junior Member

After searching the forum for my query there is nothing i can find that would resolve my problem...

Report message to a moderator

Re: MultiBlocks [message #165183 is a reply to message #165028]

Tue, 28 March 2006 18:26

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

Senior Member
Account Moderator

The problem as I see it from your post is that you are 'inserting' a record when you should be 'retrieving' a record. Please consider rebuilding your form using the Oracle standard master - detail relationship, and not the non-database block method.

David

Report message to a moderator

Previous Topic:	UTF-8 Conversion
Next Topic:	Total

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 22:06:30 CST 2025