Create a connect to tabel eith a diffrent schema ?

Mohamed_Zayed

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

krzychub83

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.

bbrown

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?

Mohamed_Zayed

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