Three Table Boxes on a form

slmaluwa
Member Posts: 366
hi there
I am trying to create a header/details type form with three tablebox (or subform) in a main form. ex:
TB1: list filtered records from Customer table. and User selects one record
TB2: List all the Posted Invoices belong to the above selected customer. User selects one Invoice
TB3: List all items (Sales Line) belongs to the above selected invoice.
I have already created 3 forms (lists) for the above record types and put on the mail form.
But, i don't know how to link these sub forms to achieve the functionality I need.
Can someone help me with a sample??
Regards
Maluwa
I am trying to create a header/details type form with three tablebox (or subform) in a main form. ex:
TB1: list filtered records from Customer table. and User selects one record
TB2: List all the Posted Invoices belong to the above selected customer. User selects one Invoice
TB3: List all items (Sales Line) belongs to the above selected invoice.
I have already created 3 forms (lists) for the above record types and put on the mail form.
But, i don't know how to link these sub forms to achieve the functionality I need.
Can someone help me with a sample??
Regards
Maluwa
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
0
Answers
-
Doesn't nav already do this?
Go tot the customer card - there are several ways of seeing the posted invoices for that customer & then seeing the invoice & lines.
:whistle:
& the Navigate button!0 -
Thanks for the reply.
Yes, but, this is a specific requirement for the client to bring them to one screen for auditing purposes.
Also, I am trying to learn how to link and manipulate subforms in this way.
Can you please help me?"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."0 -
one way of quickly getting to the header & lines of a document is you could add to the OnLookup trigger of the Document No if the customer ledger entries (for example) - then with one click lookup it will bring you right to the doc you want.
-
Name
DataType
Subtype
Navigate
Form
Navigate
PostedSalesForm
Form
Posted Sales Invoice
PostedCreditForm
Form
Posted Sales Credit Memo
PostedPaymentForm
Form
Posted Deposits
PostedSalesInv
Record
Sales Invoice Header
PostedCreditInv
Record
Sales Cr.Memo Header
CLE
Record
Cust. Ledger Entry
PostedPaymentInv
Record
Posted Deposit HeaderOnLookup(VAR Text : Text[1024];) : Boolean CASE "Document Type" OF "Document Type"::"Credit Memo": BEGIN CLEAR(PostedCreditForm); PostedCreditInv.SETFILTER(PostedCreditInv."No.","Document No."); PostedCreditForm.LOOKUPMODE(TRUE ); PostedCreditForm.SETTABLEVIEW(PostedCreditInv); PostedCreditForm.RUNMODAL; END END; CASE "Document Type" OF "Document Type"::Invoice: BEGIN CLEAR(PostedSalesForm); PostedSalesInv.SETFILTER(PostedSalesInv."No.","Document No."); PostedSalesForm.LOOKUPMODE(TRUE ); PostedSalesForm.SETTABLEVIEW(PostedSalesInv); PostedSalesForm.RUNMODAL; END END; CASE "Document Type" OF "Document Type"::Payment: BEGIN CLEAR(PostedPaymentForm); PostedPaymentInv.SETFILTER(PostedPaymentInv."No.","Document No."); PostedPaymentForm.LOOKUPMODE(TRUE ); PostedPaymentForm.SETTABLEVIEW(PostedPaymentInv); PostedPaymentForm.RUNMODAL; END END;
0 -
Also take a look at this download
It's a multiple subform sample
http://www.mibuso.com/dlinfo.asp?FileID=2900 -
Thank you
I was able to learn and solve the problem using the download mentioned"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions