 VB Style Input Feeding. [message #330371] |
Sun, 29 June 2008 23:26  |
|
|
Hi,
the case is like this
:
a Purchase Form (similarly a sales form)
having master detial relationship.
after input from master the user goes to the detial block for feeding individual items to purchase / sale.
the detail block is tabular. But now my client desires that instead of multiple records (in detial block) to show. he wants single record for feeding data, and the items should be displayed below. Next product record should be entered from the same record and it should also be displayed blow. (some what like VB input style format).
further more. when he needs to modify any record. he should click that record (probably a button) and that record should be displayed in the single feding line for editing.
-
Attachment: sales.jpg
(Size: 138.16KB, Downloaded 3305 times)
|
|
|
|
|
|
| Re: VB Style Input Feeding. [message #330562 is a reply to message #330371] |
Mon, 30 June 2008 08:06  |
|
|
my client wants single record for feeding data, and the items should be displayed below. Next product record should be entered from the same record and it should also be displayed blow. (some what like VB input style format).
if u have seen, a single record feeding and a grid (excel / access) like format being displayed below. the records are displayed on that grid after fed from the input.
he wants somewhat like that thing,
and how to achieve this with Forms.
[Updated on: Mon, 30 June 2008 08:09] Report message to a moderator |
|
|
|
| Re: VB Style Input Feeding. [message #330568 is a reply to message #330562] |
Mon, 30 June 2008 08:30 |
cjack
Messages: 22
Registered: June 2008
|
Junior Member |
|
|
1. Change the line detail as multiple records style;
2. Add a button to the line detail level, this button is used to go to the feeding screen/window;
the new button code like below:
:blk_line.item_code:=:current.item_code;--current means then current line detail (multiple records) block name.
......
go_block('blk_line');
3. Create a window name win_line( or your required), set Modal 'Yes';
4. Create a canvas name can_line, set window win_line;
5. Create a data block which is no data source name blk_line, create some data block of fields as the all current line detail fields and a button, the new data block fields will be used to display or modify the line fields, so have to same as the line fields( including validation);
then new button code like follows:
:current.item_code:=:blk_line.item_code;
....
hide_window('win_line');
go_block('current');
|
|
|
|
| Re: VB Style Input Feeding. [message #330990 is a reply to message #330371] |
Wed, 02 July 2008 01:27 |
|
|
thank you for the assistance.
====
this is the final look for the purchase form with vb style input.
====
have added a stacked canvas for the same details item and is allowed to be queried only. NO DML allowed.
Also have added the status (open / closed)for the current invoice being entered to tackle the trigger manipulation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
