 Really Need Help [message #338847] |
Wed, 06 August 2008 02:03  |
fadhzone
Messages: 61
Registered: April 2008
|
Member |
|
|
Hi All
For over a month i studied a new form that i must prepare for the new General Ledger System (Account Use).
I'm new in oracle and of course new in cursor & looping use.
For the first main form,the details like this:
There are 2 parts;Payment(Have line no,payee code,cheque date,reference no,remarks,and total amount) and second part is Payment detail(Have line no,account code,debit amt).these 2 parts have multiple lines based on the user input..
e.g : fisrt record(first payee) may have multiple payments have been made.there for one payee have many payments.
then,the user will key in the second payee.when this happen,the second block will be clear and insert to hidden block(as my boss told me).the total amount at first block is total debit amount at second block.
the problem is i really don't know how to do it.
i can do checking for each items on myself but the whole process is really make me sick..
i hope you guys can help me..i can't copy and paste people system but it will make me learn nothing...
thank you
|
|
|
|
| Re: Really Need Help [message #338885 is a reply to message #338847] |
Wed, 06 August 2008 03:18  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As far as I understood, it looks like a master-detail form (where master block ("payee" in your example) will have a detail block ("payments")). That's quite straightforward; Forms creates master-detail relationships using Data Block Wizard - just let it do the job (carefully read what Wizard wants to know and answer as good as you can).
Form will - by default - work properly. All other details (for example, fetching foreign key values, date formatting, etc. can be done later).
| Quote: | user will key in the second payee (and) the second block will be clear and insert to hidden block(as my boss told me)
|
I don't quite understand that; it is a default behaviour - when a new record is opened in the master block, detail block is cleared and waits for user's input. What "hidden block" is your boss talking about? There's nothing "hidden" (at least, I can't remember anything).
You've mentioned cursors and loops. In my opinion, you don't need any of these. List of values in the first block will return "payees", list of values in the second block will return "payments" and that should be all; no cursors, no loops.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
