Item Detail entry in Purchase Lline table.

upasanisandip

Hi everyone,
I have one problem.
In purchase order form when user enters quantity in purchase line I want to add again the datail of that item.
For that I have created 1 new table.

Enabled Field No. Field Name Data Type Length Description
Yes 1 Vendor Code Code 10
Yes 2 Item Code Code 10
Yes 3 Chasis No. Code 10
Yes 4 Receipt No Code 10
Yes 5 Invoice No Code 10

Means when user selects 5 quantity in purchase line that new form created by me will appear and user will enter 5 chasis no. for that 5 quantity.
How can I solve this prob. pl. help


Thanks,

Sandip.

bbrown

You will need to relate your new table to the Purchase Line table so you may establish a link. Add the following fields to your table as the primary key (data types should match Purchase Line table):

10 "Document Type"
20 "Document No."
30 "Line No."

Create a form to display/edit new table.

Add code to the Purchase Order Subform to populate the new table and run the form. Use the OnAfterValidate trigger of the textbox. You will also need to handle the situation where a quantity is changed after this table has related data.

Suggestion:

Rather than keeping posted info ("Receipt No.", "Invoice No.") in this table, create a posted version of the table and write the data during posting. Look at "Document Dimensions" and "Posted Document Dimensions" as an example.

Hope this will get you started.

upasanisandip

Thanks bbrown,
My work is started by your suggestion