Hi,
I try to write a form so the user can create relationship between tables. is they a way to dynamically get the list of table that navision has without hardcoding it.
What are you trying to do? Your description doesn't make much sence to me.
anyway perhaps this can help..
Here is the List of Navision System Tables:
Object ID Object Name
2000000001 Object
2000000007 Date
2000000009 Session
2000000010 Database File
2000000020 Drive
2000000022 File
2000000024 Monitor
2000000026 Integer
2000000028 Table Information
2000000029 System Object
2000000037 Performance
2000000038 AllObj
2000000039 Printer
2000000040 License Information
2000000041 Field
2000000042 OLE Control
2000000043 License Permission
2000000044 Permission Range
2000000045 Windows Language
2000000046 Automation Server
2000000047 Server
2000000048 Database
2000000049 Code Coverage
2000000050 Windows Object
2000000052 Windows Group Member
2000000055 SID - Account ID
2000000056 User SID
2000000058 AllObjWithCaption
2000000059 Breakpoint
2000000063 Key
sorry been unclear...
I have a Form that will take all the folders from the sharepoint and populate in the table then use can click on button to bring up the a list that contain the navision table such as purchase header, sales header, item, customer, vendor.. so the user can create the relationship between the sharepoint folder and navision table.
So my question is there a way the system will generate the all the table name from the navison so the user can choose. Right now I create an option datatype then hardcode the table name in it. I want to change it system can auto generate the list.
There is a system table Object which you can use for that purpose. Use the form wizard and create a Tabular-Type Form for table "Object", put all fields on the form and select "Preview". Now you have an idea about the information that's available in that table.
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
Comments
anyway perhaps this can help..
Here is the List of Navision System Tables:
Object ID Object Name
2000000001 Object
2000000007 Date
2000000009 Session
2000000010 Database File
2000000020 Drive
2000000022 File
2000000024 Monitor
2000000026 Integer
2000000028 Table Information
2000000029 System Object
2000000037 Performance
2000000038 AllObj
2000000039 Printer
2000000040 License Information
2000000041 Field
2000000042 OLE Control
2000000043 License Permission
2000000044 Permission Range
2000000045 Windows Language
2000000046 Automation Server
2000000047 Server
2000000048 Database
2000000049 Code Coverage
2000000050 Windows Object
2000000052 Windows Group Member
2000000055 SID - Account ID
2000000056 User SID
2000000058 AllObjWithCaption
2000000059 Breakpoint
2000000063 Key
http://www.BiloBeauty.com
http://www.autismspeaks.org
I have a Form that will take all the folders from the sharepoint and populate in the table then use can click on button to bring up the a list that contain the navision table such as purchase header, sales header, item, customer, vendor.. so the user can create the relationship between the sharepoint folder and navision table.
So my question is there a way the system will generate the all the table name from the navison so the user can choose. Right now I create an option datatype then hardcode the table name in it. I want to change it system can auto generate the list.