Home » Developer & Programmer » Forms » VB Style Input Feeding. (Forms 6i, OS: Xp/2000)
icon4.gif  VB Style Input Feeding. [message #330371] Sun, 29 June 2008 23:26 Go to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

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.

./fa/4537/0/

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 1597 times)
Re: VB Style Input Feeding. [message #330555 is a reply to message #330371] Mon, 30 June 2008 07:48 Go to previous messageGo to next message
cjack
Messages: 22
Registered: June 2008
Junior Member
What's wrong with this?
Re: VB Style Input Feeding. [message #330562 is a reply to message #330371] Mon, 30 June 2008 08:06 Go to previous messageGo to next message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

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 Go to previous messageGo to next message
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 Go to previous message
itech
Messages: 168
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

thank you for the assistance.
====
this is the final look for the purchase form with vb style input.

./fa/4553/0/

====
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.
Previous Topic: Sqlloader from unix box
Next Topic: dynamic IN operator values
Goto Forum:
  


Current Time: Thu Dec 08 21:53:28 CST 2016

Total time taken to generate the page: 0.13030 seconds