| I want to change property of block with a trigger. [message #213801] |
Fri, 12 January 2007 06:20  |
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. 
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. 
[Updated on: Fri, 12 January 2007 06:41] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
