binky
Active Member
Is it possible to create a View in MSSQL and then have JDE recognize it as a table?
My thought was that the specifications wouldn't be created for JDE without creating the table through OMW. What if I created a tabel with the three fields I required then deleted the table in MSSQL and created the required View with a custom query and gave it the same name as the table?
Any thoughts or comments would be greatly appreciated!
My thought was that the specifications wouldn't be created for JDE without creating the table through OMW. What if I created a tabel with the three fields I required then deleted the table in MSSQL and created the required View with a custom query and gave it the same name as the table?
Any thoughts or comments would be greatly appreciated!