Home » Developer & Programmer » Forms » I want to change property of block with a trigger.
I want to change property of block with a trigger. [message #213801] Fri, 12 January 2007 06:20 Go to next message
Smith_X
Messages: 56
Registered: January 2007
Member
Short Question
How do I change block property by trigger.

The Whole Story
I have tables below,

1. Raw Material (MTR)
2. Inventory (IVT)
3. Purchase Order (PO)
4. Purchase Order Line Item (POI)
5. Manufacturing Order (MO)
6. Manufacturing Order Line Item (MOI)
7. Goods Received (GR)
8. Goods Received Line Item (GRI)

Next, I have to create a document which called "Goods Received". This document used for records both Inventory and Raw Material that Warehouse of the Company would received. So, the problem that I faced in this moments is.. How do I create form of the "Goods Received".?

Due to the Goods Received Note will handle both Raw Material and Inventory. So, I need to create Goods Received Note with in only one form. But Goods Received (GR) must have the reference records which use to track the references documents (Which PO or MO is the cause of this GR?) ---> I mark this is as A.

In the Goods Received Line Item, there are two associations to the Inventory Table and Raw Material Table, too. ---> I mark this is as B.

Both A. and B. have the same problem. I mean in the form builder, I have to create only 1 text item which user can insert the PO number or MO number.. then, I have to write a trigger to handle the whole process. Now, what I think is .. I will create a radio button allow user to choose the type of inventory he may receives. If he choose radio button for Inventory, then the code in my form should prepare to insert the data in proper table (MO table).

As far as I imagine... The lov is also changes according to the choice that user is selected, too. Then, I have to prepare some record groups..

Well, I just start form builder about 2 weeks and this is my homework that I need to finish really soon if I want to graduated this semester. That's why I came here. Embarassed

Anybody could please give me a flickered light which allow me to see some direction?

(I have secondary operation, too. just create two documents. one to handle the received inventory and the other handle the received raw material... If I feel I face with a deadened pit, then I have no choice to choose the easier way but I'm also want to learn the other solution.)

EDIT#1 - one of my generous friend give me another alternate solution : Create two blocks with the same item on the same position and use radio button to control the visible of each block (hide one and show another or vice versa.) but I still want to direct method. Smile

[Updated on: Fri, 12 January 2007 06:41]

Report message to a moderator

Re: I want to change property of block with a trigger. [message #214333 is a reply to message #213801] Mon, 15 January 2007 22:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: I want to change property of block with a trigger. [message #214422 is a reply to message #213801] Tue, 16 January 2007 07:12 Go to previous messageGo to next message
Smith_X
Messages: 56
Registered: January 2007
Member
T_T

actually, I did not success solve my problem. Due to the time limitation, I use the alternate procedure to fixed my problem instead. I create two tables to handle each received document. Then, I have two forms each received document, too. Smile

I think I can't go back to redesign the whole thing again because the time which I have is very tight. (I'm really want to graduate this semester.) but I still want to know how to do it and hope that it would be useful for some users in future, too. Smile
Re: I want to change property of block with a trigger. [message #214521 is a reply to message #214422] Tue, 16 January 2007 19:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I agree with having two tables.

You could have handled them in the same form by using a tabbed canvas. One tab for PO and the other for MO. To the user they will look the same but to the database they are different.

David
Re: I want to change property of block with a trigger. [message #214535 is a reply to message #213801] Tue, 16 January 2007 22:45 Go to previous message
Smith_X
Messages: 56
Registered: January 2007
Member
Thank you very much David. I had been never touch the tab canvas button since I use it at the first time and I feel it's too much complicate.

But I will take a note for that and will have some time to look for it later Smile
Previous Topic: Goal Seek option in forms 9i
Next Topic: DELETING RECORDS - MASTER-DETAIL
Goto Forum:
  


Current Time: Tue Dec 06 04:14:47 CST 2016

Total time taken to generate the page: 0.05945 seconds