Create a connect to tabel eith a diffrent schema ?

Mohamed_ZayedMohamed_Zayed Member Posts: 39
Dear All,
All my tabels are lets say located under Navision Database with this schema 123-

What If i have another tabels with a different schema that I want to be able to access from object designer(Lets say C/Side), How can I do this?

Iam not sure, I heard something like creating XML-port? is this what I need? if yes, then how can I do this?

I have the tabels already in my sql server, but I just want to connect to them.


Thanks alot
zayed

Comments

  • krzychub83krzychub83 Member Posts: 120
    Create a view in SQL, under your NAV database, which name would be YourNAVCompanyName$YourTableName, and which would select data from table located under different schema. Then in NAV create a table having name YourTableName, the same structure as the view and LinkedObject property set to True.
  • bbrownbbrown Member Posts: 3,268
    Is this table in the NAV database? If so, why is it in a different schema? Rule #1 - Never create tables in the NAV database from outside the NAV development environment.

    Or are we talking about a different database here?
    There are no bugs - only undocumented features.
  • Mohamed_ZayedMohamed_Zayed Member Posts: 39
    Yes. Its a non Navision DB

    Would you please tell me how to create this connection? I want to take the values from this tabel into my Navision.


    Thanks alot,
    Zayed
Sign In or Register to comment.