Create Progress View

Yahoo Archive
1
For the Fortis application that we are using we have it using 2 tables.
Apparently we have to setup a view in progress so these will be held in
one table instead of two. Has anyone ever created a view in progress? If
so how do you accomplish this?



CREATE VIEW FortisCheck AS
SELECT CheckHed.CheckNum, CheckHed.Name, CheckHed.CheckData,
APTran.InvoiceNum
FROM pub.CheckHed, pub.APTran where CheckHed.CheckNum = APTran.CheckNum;
commit work;





Thanks,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]