stan
March 30, 2007, 1:41am
1
Hai There, I have query like this
SELECT [Company_Name$Sales Shipment Header].[Sell-to Customer No_] as [Kode Customer],
[Company_Name$Sales Shipment Header].[Sell-to Customer Name] as [Nama Customer],
[Company_Name$Sales Shipment Header].[External Document No_] as [No PO],
[Company_Name$Sales Shipment Header].[Order No_] As [No SO],
[Company_Name$Sales Shipment Header].[Order Date] as [Tgl SO],
[Company_Name$Sales Shipment Header].[Shortcut Dimension 2 Code] as [Kode Project],
[Company_Name$Sales Shipment Header].[No_] As [No DO],
[Company_Name$Sales Shipment Header].[Shipment Date] as [Tgl DO],
[Company_Name$Sales Invoice Header].[No_] As [No Invoice],
[Company_Name$Sales Invoice Header].[Posting Date] as [Tgl Invoice]
FROM [Company_Name$Sales Shipment Header]
LEFT JOIN [Company_Name$Sales Invoice Header]
ON [Company_Name$Sales Invoice Header].[Order No_]
= [Company_Name$Sales Shipment Header].[Order No_]
ORDER BY [Company_Name$Sales Shipment Header].[Order Date] Desc
how we create form which showing data like this query on navision?
thanx for your information
admin1
March 30, 2007, 1:54am
2
Well it really depends on what development system you are using: C/SIDE, Visual Studio or?
stan
March 30, 2007, 2:46am
3
i’m using object designer in navision C/SIDE
stryk
March 30, 2007, 2:59am
4
Hi!
You could create a SQL site “View” of this SELECT statement. Then you could create a table in NAV - view-name = table-name; identical field-names and data-types - and link it to this “View” by setting the NAV table property “LinkedObject”. Then you should be able to use this table as any other one (reading, not writing)!
admin1
March 30, 2007, 3:10am
5
Well, then you don’t even need to think about the SQL Select statement. Just create a form. Point out the table and select the fields. And run the form.
stan
March 30, 2007, 4:00am
6
that’s the point
i don’t know to connect one table to another like the sql statement
stan
March 30, 2007, 4:01am
7
that’s the point
i don’t know how to connect one table to another like the sql statement
Open Sales Order Form / SubForm
Form ID: 42 and 46
I recommend reading Navision Application Designer’s Guide, most of your questions will be answered there.