Hi I have a customer who would like to update a non NF SQL database, whenever posting in NF. The NF can be ether a naive NF or a SQL NF. I suppose this is possible via the ODBC driver? If so, is there anything I should be careful about? What about updating the other way around – from the non-NF SQL to NF? Thanks
If you are using SQL you can create a view in the NF database on the SQL server into any table that MS SQL 7 can see. Then you create the same table in Navision, calling it the same name. You can then see the new table… you shouldnt have any problems from there… Craig Bradney Project Manager - Technical Navision Solutions & Services Deloitte Growth Solutions Deloitte Touche Tohmatsu P:+61-2-9322-7796 F:+61-2-9322-7502 E:craig_bradney@deloitte.com.au