I did discover that if I delete all records in PBRWORK it works. If I do not add all of the fields - it works. There seems to be something related to the size of the resulting view. I can delete all but a few records and add most of the fields and it works - or - I can delete only a few records in PBRWORK and add only a few fields and it works. PBRWORK has around 2.2 million records if that helps any.

Here is the code from the View Designer:

SELECT *;
FROM ;
mc!pbrwork ;
INNER JOIN mc!pbrmain ;
ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber

DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","mc!pbrwork,mc!pbrmain")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".primarykey_a","Field","DataType","I")
DBSetProp(ThisView+".primarykey_a","Field","UpdateName","mc!pbrwork.primarykey")
DBSetProp(ThisView+".primarykey_a","Field","KeyField",.F.)
DBSetProp(ThisView+".primarykey_a","Field","Updatable",.T.)

DBSetProp(ThisView+".pbrmainfk","Field","DataType","I")
DBSetProp(ThisView+".pbrmainfk","Field","UpdateName","mc!pbrwork.pbrmainfk")
DBSetProp(ThisView+".pbrmainfk","Field","KeyField",.F.)
DBSetProp(ThisView+".pbrmainfk","Field","Updatable",.T.)

DBSetProp(ThisView+".linenumber","Field","DataType","N(3)")
DBSetProp(ThisView+".linenumber","Field","UpdateName","mc!pbrwork.linenumber")
DBSetProp(ThisView+".linenumber","Field","KeyField",.F.)
DBSetProp(ThisView+".linenumber","Field","Updatable",.T.)

DBSetProp(ThisView+".linetype","Field","DataType","N(1)")
DBSetProp(ThisView+".linetype","Field","UpdateName","mc!pbrwork.linetype")
DBSetProp(ThisView+".linetype","Field","KeyField",.F.)
DBSetProp(ThisView+".linetype","Field","Updatable",.T.)

DBSetProp(ThisView+".billbdate","Field","DataType","D")
DBSetProp(ThisView+".billbdate","Field","UpdateName","mc!pbrwork.billbdate")
DBSetProp(ThisView+".billbdate","Field","KeyField",.F.)
DBSetProp(ThisView+".billbdate","Field","Updatable",.T.)

DBSetProp(ThisView+".billedate","Field","DataType","D")
DBSetProp(ThisView+".billedate","Field","UpdateName","mc!pbrwork.billedate")
DBSetProp(ThisView+".billedate","Field","KeyField",.F.)
DBSetProp(ThisView+".billedate","Field","Updatable",.T.)

DBSetProp(ThisView+".billcodefk","Field","DataType","I")
DBSetProp(ThisView+".billcodefk","Field","UpdateName","mc!pbrwork.billcodefk")
DBSetProp(ThisView+".billcodefk","Field","KeyField",.F.)
DBSetProp(ThisView+".billcodefk","Field","Updatable",.T.)

DBSetProp(ThisView+".modifier1","Field","DataType","C(2)")
DBSetProp(ThisView+".modifier1","Field","UpdateName","mc!pbrwork.modifier1")
DBSetProp(ThisView+".modifier1","Field","KeyField",.F.)
DBSetProp(ThisView+".modifier1","Field","Updatable",.T.)

DBSetProp(ThisView+".modifier2","Field","DataType","C(2)")
DBSetProp(ThisView+".modifier2","Field","UpdateName","mc!pbrwork.modifier2")
DBSetProp(ThisView+".modifier2","Field","KeyField",.F.)
DBSetProp(ThisView+".modifier2","Field","Updatable",.T.)

DBSetProp(ThisView+".whichdiag","Field","DataType","C(4)")
DBSetProp(ThisView+".whichdiag","Field","UpdateName","mc!pbrwork.whichdiag")
DBSetProp(ThisView+".whichdiag","Field","KeyField",.F.)
DBSetProp(ThisView+".whichdiag","Field","Updatable",.T.)

DBSetProp(ThisView+".svcplace","Field","DataType","N(2)")
DBSetProp(ThisView+".svcplace","Field","UpdateName","mc!pbrwork.svcplace")
DBSetProp(ThisView+".svcplace","Field","KeyField",.F.)
DBSetProp(ThisView+".svcplace","Field","Updatable",.T.)

DBSetProp(ThisView+".rxnum","Field","DataType","C(10)")
DBSetProp(ThisView+".rxnum","Field","UpdateName","mc!pbrwork.rxnum")
DBSetProp(ThisView+".rxnum","Field","KeyField",.F.)
DBSetProp(ThisView+".rxnum","Field","Updatable",.T.)

DBSetProp(ThisView+".rxdoc","Field","DataType","C(15)")
DBSetProp(ThisView+".rxdoc","Field","UpdateName","mc!pbrwork.rxdoc")
DBSetProp(ThisView+".rxdoc","Field","KeyField",.F.)
DBSetProp(ThisView+".rxdoc","Field","Updatable",.T.)

DBSetProp(ThisView+".cost","Field","DataType","N(9,2)")
DBSetProp(ThisView+".cost","Field","UpdateName","mc!pbrwork.cost")
DBSetProp(ThisView+".cost","Field","KeyField",.F.)
DBSetProp(ThisView+".cost","Field","Updatable",.T.)

DBSetProp(ThisView+".qty","Field","DataType","N(5)")
DBSetProp(ThisView+".qty","Field","UpdateName","mc!pbrwork.qty")
DBSetProp(ThisView+".qty","Field","KeyField",.F.)
DBSetProp(ThisView+".qty","Field","Updatable",.T.)

DBSetProp(ThisView+".wccprice","Field","DataType","N(9,2)")
DBSetProp(ThisView+".wccprice","Field","UpdateName","mc!pbrwork.wccprice")
DBSetProp(ThisView+".wccprice","Field","KeyField",.F.)
DBSetProp(ThisView+".wccprice","Field","Updatable",.T.)

DBSetProp(ThisView+".adjustment","Field","DataType","N(9,2)")
DBSetProp(ThisView+".adjustment","Field","UpdateName","mc!pbrwork.adjustment")
DBSetProp(ThisView+".adjustment","Field","KeyField",.F.)
DBSetProp(ThisView+".adjustment","Field","Updatable",.T.)

DBSetProp(ThisView+".bcbsallow","Field","DataType","N(9,2)")
DBSetProp(ThisView+".bcbsallow","Field","UpdateName","mc!pbrwork.bcbsallow")
DBSetProp(ThisView+".bcbsallow","Field","KeyField",.F.)
DBSetProp(ThisView+".bcbsallow","Field","Updatable",.T.)

DBSetProp(ThisView+".whoedited","Field","DataType","C(5)")
DBSetProp(ThisView+".whoedited","Field","UpdateName","mc!pbrwork.whoedited")
DBSetProp(ThisView+".whoedited","Field","KeyField",.F.)
DBSetProp(ThisView+".whoedited","Field","Updatable",.T.)

DBSetProp(ThisView+".dateedited","Field","DataType","D")
DBSetProp(ThisView+".dateedited","Field","UpdateName","mc!pbrwork.dateedited")
DBSetProp(ThisView+".dateedited","Field","KeyField",.F.)
DBSetProp(ThisView+".dateedited","Field","Updatable",.T.)

DBSetProp(ThisView+".notes","Field","DataType","M")
DBSetProp(ThisView+".notes","Field","UpdateName","mc!pbrwork.notes")
DBSetProp(ThisView+".notes","Field","KeyField",.F.)
DBSetProp(ThisView+".notes","Field","Updatable",.T.)

DBSetProp(ThisView+".linestmt1","Field","DataType","C(3)")
DBSetProp(ThisView+".linestmt1","Field","UpdateName","mc!pbrwork.linestmt1")
DBSetProp(ThisView+".linestmt1","Field","KeyField",.F.)
DBSetProp(ThisView+".linestmt1","Field","Updatable",.T.)

DBSetProp(ThisView+".linestmt2","Field","DataType","C(3)")
DBSetProp(ThisView+".linestmt2","Field","UpdateName","mc!pbrwork.linestmt2")
DBSetProp(ThisView+".linestmt2","Field","KeyField",.F.)
DBSetProp(ThisView+".linestmt2","Field","Updatable",.T.)

DBSetProp(ThisView+".ocompsaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".ocompsaved","Field","UpdateName","mc!pbrwork.ocompsaved")
DBSetProp(ThisView+".ocompsaved","Field","KeyField",.F.)
DBSetProp(ThisView+".ocompsaved","Field","Updatable",.T.)

DBSetProp(ThisView+".fcompsaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fcompsaved","Field","UpdateName","mc!pbrwork.fcompsaved")
DBSetProp(ThisView+".fcompsaved","Field","KeyField",.F.)
DBSetProp(ThisView+".fcompsaved","Field","Updatable",.T.)

DBSetProp(ThisView+".claimantfk","Field","DataType","I")
DBSetProp(ThisView+".claimantfk","Field","UpdateName","mc!pbrmain.claimantfk")
DBSetProp(ThisView+".claimantfk","Field","KeyField",.F.)
DBSetProp(ThisView+".claimantfk","Field","Updatable",.T.)

DBSetProp(ThisView+".primarykey_b","Field","DataType","I")
DBSetProp(ThisView+".primarykey_b","Field","UpdateName","mc!pbrmain.primarykey")
DBSetProp(ThisView+".primarykey_b","Field","KeyField",.F.)
DBSetProp(ThisView+".primarykey_b","Field","Updatable",.T.)

DBSetProp(ThisView+".providerfk","Field","DataType","I")
DBSetProp(ThisView+".providerfk","Field","UpdateName","mc!pbrmain.providerfk")
DBSetProp(ThisView+".providerfk","Field","KeyField",.F.)
DBSetProp(ThisView+".providerfk","Field","Updatable",.T.)

DBSetProp(ThisView+".provacctnum","Field","DataType","M")
DBSetProp(ThisView+".provacctnum","Field","UpdateName","mc!pbrmain.provacctnum")
DBSetProp(ThisView+".provacctnum","Field","KeyField",.F.)
DBSetProp(ThisView+".provacctnum","Field","Updatable",.T.)

DBSetProp(ThisView+".provkey","Field","DataType","C(6)")
DBSetProp(ThisView+".provkey","Field","UpdateName","mc!pbrmain.provkey")
DBSetProp(ThisView+".provkey","Field","KeyField",.F.)
DBSetProp(ThisView+".provkey","Field","Updatable",.T.)

DBSetProp(ThisView+".hosptype","Field","DataType","N(1)")
DBSetProp(ThisView+".hosptype","Field","UpdateName","mc!pbrmain.hosptype")
DBSetProp(ThisView+".hosptype","Field","KeyField",.F.)
DBSetProp(ThisView+".hosptype","Field","Updatable",.T.)

DBSetProp(ThisView+".doctor","Field","DataType","C(25)")
DBSetProp(ThisView+".doctor","Field","UpdateName","mc!pbrmain.doctor")
DBSetProp(ThisView+".doctor","Field","KeyField",.F.)
DBSetProp(ThisView+".doctor","Field","Updatable",.T.)

DBSetProp(ThisView+".networkid","Field","DataType","C(9)")
DBSetProp(ThisView+".networkid","Field","UpdateName","mc!pbrmain.networkid")
DBSetProp(ThisView+".networkid","Field","KeyField",.F.)
DBSetProp(ThisView+".networkid","Field","Updatable",.T.)

DBSetProp(ThisView+".diag1","Field","DataType","C(5)")
DBSetProp(ThisView+".diag1","Field","UpdateName","mc!pbrmain.diag1")
DBSetProp(ThisView+".diag1","Field","KeyField",.F.)
DBSetProp(ThisView+".diag1","Field","Updatable",.T.)

DBSetProp(ThisView+".diag2","Field","DataType","C(5)")
DBSetProp(ThisView+".diag2","Field","UpdateName","mc!pbrmain.diag2")
DBSetProp(ThisView+".diag2","Field","KeyField",.F.)
DBSetProp(ThisView+".diag2","Field","Updatable",.T.)

DBSetProp(ThisView+".diag3","Field","DataType","C(5)")
DBSetProp(ThisView+".diag3","Field","UpdateName","mc!pbrmain.diag3")
DBSetProp(ThisView+".diag3","Field","KeyField",.F.)
DBSetProp(ThisView+".diag3","Field","Updatable",.T.)

DBSetProp(ThisView+".diag4","Field","DataType","C(5)")
DBSetProp(ThisView+".diag4","Field","UpdateName","mc!pbrmain.diag4")
DBSetProp(ThisView+".diag4","Field","KeyField",.F.)
DBSetProp(ThisView+".diag4","Field","Updatable",.T.)

DBSetProp(ThisView+".diag5","Field","DataType","C(5)")
DBSetProp(ThisView+".diag5","Field","UpdateName","mc!pbrmain.diag5")
DBSetProp(ThisView+".diag5","Field","KeyField",.F.)
DBSetProp(ThisView+".diag5","Field","Updatable",.T.)

DBSetProp(ThisView+".diag6","Field","DataType","C(5)")
DBSetProp(ThisView+".diag6","Field","UpdateName","mc!pbrmain.diag6")
DBSetProp(ThisView+".diag6","Field","KeyField",.F.)
DBSetProp(ThisView+".diag6","Field","Updatable",.T.)

DBSetProp(ThisView+".diag7","Field","DataType","C(5)")
DBSetProp(ThisView+".diag7","Field","UpdateName","mc!pbrmain.diag7")
DBSetProp(ThisView+".diag7","Field","KeyField",.F.)
DBSetProp(ThisView+".diag7","Field","Updatable",.T.)

DBSetProp(ThisView+".diag8","Field","DataType","C(5)")
DBSetProp(ThisView+".diag8","Field","UpdateName","mc!pbrmain.diag8")
DBSetProp(ThisView+".diag8","Field","KeyField",.F.)
DBSetProp(ThisView+".diag8","Field","Updatable",.T.)

DBSetProp(ThisView+".diag9","Field","DataType","C(5)")
DBSetProp(ThisView+".diag9","Field","UpdateName","mc!pbrmain.diag9")
DBSetProp(ThisView+".diag9","Field","KeyField",.F.)
DBSetProp(ThisView+".diag9","Field","Updatable",.T.)

DBSetProp(ThisView+".diag10","Field","DataType","C(5)")
DBSetProp(ThisView+".diag10","Field","UpdateName","mc!pbrmain.diag10")
DBSetProp(ThisView+".diag10","Field","KeyField",.F.)
DBSetProp(ThisView+".diag10","Field","Updatable",.T.)

DBSetProp(ThisView+".diag11","Field","DataType","C(5)")
DBSetProp(ThisView+".diag11","Field","UpdateName","mc!pbrmain.diag11")
DBSetProp(ThisView+".diag11","Field","KeyField",.F.)
DBSetProp(ThisView+".diag11","Field","Updatable",.T.)

DBSetProp(ThisView+".proc1","Field","DataType","C(4)")
DBSetProp(ThisView+".proc1","Field","UpdateName","mc!pbrmain.proc1")
DBSetProp(ThisView+".proc1","Field","KeyField",.F.)
DBSetProp(ThisView+".proc1","Field","Updatable",.T.)

DBSetProp(ThisView+".proc2","Field","DataType","C(4)")
DBSetProp(ThisView+".proc2","Field","UpdateName","mc!pbrmain.proc2")
DBSetProp(ThisView+".proc2","Field","KeyField",.F.)
DBSetProp(ThisView+".proc2","Field","Updatable",.T.)

DBSetProp(ThisView+".proc3","Field","DataType","C(4)")
DBSetProp(ThisView+".proc3","Field","UpdateName","mc!pbrmain.proc3")
DBSetProp(ThisView+".proc3","Field","KeyField",.F.)
DBSetProp(ThisView+".proc3","Field","Updatable",.T.)

DBSetProp(ThisView+".proc4","Field","DataType","C(4)")
DBSetProp(ThisView+".proc4","Field","UpdateName","mc!pbrmain.proc4")
DBSetProp(ThisView+".proc4","Field","KeyField",.F.)
DBSetProp(ThisView+".proc4","Field","Updatable",.T.)

DBSetProp(ThisView+".proc5","Field","DataType","C(4)")
DBSetProp(ThisView+".proc5","Field","UpdateName","mc!pbrmain.proc5")
DBSetProp(ThisView+".proc5","Field","KeyField",.F.)
DBSetProp(ThisView+".proc5","Field","Updatable",.T.)

DBSetProp(ThisView+".proc6","Field","DataType","C(4)")
DBSetProp(ThisView+".proc6","Field","UpdateName","mc!pbrmain.proc6")
DBSetProp(ThisView+".proc6","Field","KeyField",.F.)
DBSetProp(ThisView+".proc6","Field","Updatable",.T.)

DBSetProp(ThisView+".dateenter","Field","DataType","D")
DBSetProp(ThisView+".dateenter","Field","UpdateName","mc!pbrmain.dateenter")
DBSetProp(ThisView+".dateenter","Field","KeyField",.F.)
DBSetProp(ThisView+".dateenter","Field","Updatable",.T.)

DBSetProp(ThisView+".whoenteredfk","Field","DataType","C(5)")
DBSetProp(ThisView+".whoenteredfk","Field","UpdateName","mc!pbrmain.whoenteredfk")
DBSetProp(ThisView+".whoenteredfk","Field","KeyField",.F.)
DBSetProp(ThisView+".whoenteredfk","Field","Updatable",.T.)

DBSetProp(ThisView+".dateclosed","Field","DataType","D")
DBSetProp(ThisView+".dateclosed","Field","UpdateName","mc!pbrmain.dateclosed")
DBSetProp(ThisView+".dateclosed","Field","KeyField",.F.)
DBSetProp(ThisView+".dateclosed","Field","Updatable",.T.)

DBSetProp(ThisView+".whoclosedfk","Field","DataType","C(5)")
DBSetProp(ThisView+".whoclosedfk","Field","UpdateName","mc!pbrmain.whoclosedfk")
DBSetProp(ThisView+".whoclosedfk","Field","KeyField",.F.)
DBSetProp(ThisView+".whoclosedfk","Field","Updatable",.T.)

DBSetProp(ThisView+".dtsuspended","Field","DataType","D")
DBSetProp(ThisView+".dtsuspended","Field","UpdateName","mc!pbrmain.dtsuspended")
DBSetProp(ThisView+".dtsuspended","Field","KeyField",.F.)
DBSetProp(ThisView+".dtsuspended","Field","Updatable",.T.)

DBSetProp(ThisView+".whosuspendedfk","Field","DataType","C(5)")
DBSetProp(ThisView+".whosuspendedfk","Field","UpdateName","mc!pbrmain.whosuspendedfk")
DBSetProp(ThisView+".whosuspendedfk","Field","KeyField",.F.)
DBSetProp(ThisView+".whosuspendedfk","Field","Updatable",.T.)

DBSetProp(ThisView+".casemanagerfk","Field","DataType","C(5)")
DBSetProp(ThisView+".casemanagerfk","Field","UpdateName","mc!pbrmain.casemanagerfk")
DBSetProp(ThisView+".casemanagerfk","Field","KeyField",.F.)
DBSetProp(ThisView+".casemanagerfk","Field","Updatable",.T.)

DBSetProp(ThisView+".hospppo","Field","DataType","N(9,2)")
DBSetProp(ThisView+".hospppo","Field","UpdateName","mc!pbrmain.hospppo")
DBSetProp(ThisView+".hospppo","Field","KeyField",.F.)
DBSetProp(ThisView+".hospppo","Field","Updatable",.T.)

DBSetProp(ThisView+".begdos","Field","DataType","D")
DBSetProp(ThisView+".begdos","Field","UpdateName","mc!pbrmain.begdos")
DBSetProp(ThisView+".begdos","Field","KeyField",.F.)
DBSetProp(ThisView+".begdos","Field","Updatable",.T.)

DBSetProp(ThisView+".enddos","Field","DataType","D")
DBSetProp(ThisView+".enddos","Field","UpdateName","mc!pbrmain.enddos")
DBSetProp(ThisView+".enddos","Field","KeyField",.F.)
DBSetProp(ThisView+".enddos","Field","Updatable",.T.)

DBSetProp(ThisView+".unrelated","Field","DataType","N(9,2)")
DBSetProp(ThisView+".unrelated","Field","UpdateName","mc!pbrmain.unrelated")
DBSetProp(ThisView+".unrelated","Field","KeyField",.F.)
DBSetProp(ThisView+".unrelated","Field","Updatable",.T.)

DBSetProp(ThisView+".unrelnotes","Field","DataType","M")
DBSetProp(ThisView+".unrelnotes","Field","UpdateName","mc!pbrmain.unrelnotes")
DBSetProp(ThisView+".unrelnotes","Field","KeyField",.F.)
DBSetProp(ThisView+".unrelnotes","Field","Updatable",.T.)

DBSetProp(ThisView+".lettstmt1","Field","DataType","C(3)")
DBSetProp(ThisView+".lettstmt1","Field","UpdateName","mc!pbrmain.lettstmt1")
DBSetProp(ThisView+".lettstmt1","Field","KeyField",.F.)
DBSetProp(ThisView+".lettstmt1","Field","Updatable",.T.)

DBSetProp(ThisView+".lettstmt2","Field","DataType","C(3)")
DBSetProp(ThisView+".lettstmt2","Field","UpdateName","mc!pbrmain.lettstmt2")
DBSetProp(ThisView+".lettstmt2","Field","KeyField",.F.)
DBSetProp(ThisView+".lettstmt2","Field","Updatable",.T.)

DBSetProp(ThisView+".lettstmt3","Field","DataType","C(3)")
DBSetProp(ThisView+".lettstmt3","Field","UpdateName","mc!pbrmain.lettstmt3")
DBSetProp(ThisView+".lettstmt3","Field","KeyField",.F.)
DBSetProp(ThisView+".lettstmt3","Field","Updatable",.T.)

DBSetProp(ThisView+".lettstmt4","Field","DataType","C(3)")
DBSetProp(ThisView+".lettstmt4","Field","UpdateName","mc!pbrmain.lettstmt4")
DBSetProp(ThisView+".lettstmt4","Field","KeyField",.F.)
DBSetProp(ThisView+".lettstmt4","Field","Updatable",.T.)

DBSetProp(ThisView+".lettcomments","Field","DataType","M")
DBSetProp(ThisView+".lettcomments","Field","UpdateName","mc!pbrmain.lettcomments")
DBSetProp(ThisView+".lettcomments","Field","KeyField",.F.)
DBSetProp(ThisView+".lettcomments","Field","Updatable",.T.)

DBSetProp(ThisView+".nocharge","Field","DataType","L")
DBSetProp(ThisView+".nocharge","Field","UpdateName","mc!pbrmain.nocharge")
DBSetProp(ThisView+".nocharge","Field","KeyField",.F.)
DBSetProp(ThisView+".nocharge","Field","Updatable",.T.)

DBSetProp(ThisView+".suspended","Field","DataType","L")
DBSetProp(ThisView+".suspended","Field","UpdateName","mc!pbrmain.suspended")
DBSetProp(ThisView+".suspended","Field","KeyField",.F.)
DBSetProp(ThisView+".suspended","Field","Updatable",.T.)

DBSetProp(ThisView+".workprinted","Field","DataType","D")
DBSetProp(ThisView+".workprinted","Field","UpdateName","mc!pbrmain.workprinted")
DBSetProp(ThisView+".workprinted","Field","KeyField",.F.)
DBSetProp(ThisView+".workprinted","Field","Updatable",.T.)

DBSetProp(ThisView+".invoiced","Field","DataType","L")
DBSetProp(ThisView+".invoiced","Field","UpdateName","mc!pbrmain.invoiced")
DBSetProp(ThisView+".invoiced","Field","KeyField",.F.)
DBSetProp(ThisView+".invoiced","Field","Updatable",.T.)

DBSetProp(ThisView+".override","Field","DataType","L")
DBSetProp(ThisView+".override","Field","UpdateName","mc!pbrmain.override")
DBSetProp(ThisView+".override","Field","KeyField",.F.)
DBSetProp(ThisView+".override","Field","Updatable",.T.)

DBSetProp(ThisView+".compedit","Field","DataType","L")
DBSetProp(ThisView+".compedit","Field","UpdateName","mc!pbrmain.compedit")
DBSetProp(ThisView+".compedit","Field","KeyField",.F.)
DBSetProp(ThisView+".compedit","Field","Updatable",.T.)

DBSetProp(ThisView+".mincharged","Field","DataType","L")
DBSetProp(ThisView+".mincharged","Field","UpdateName","mc!pbrmain.mincharged")
DBSetProp(ThisView+".mincharged","Field","KeyField",.F.)
DBSetProp(ThisView+".mincharged","Field","Updatable",.T.)

DBSetProp(ThisView+".freetrial","Field","DataType","L")
DBSetProp(ThisView+".freetrial","Field","UpdateName","mc!pbrmain.freetrial")
DBSetProp(ThisView+".freetrial","Field","KeyField",.F.)
DBSetProp(ThisView+".freetrial","Field","Updatable",.T.)

DBSetProp(ThisView+".isrecon","Field","DataType","L")
DBSetProp(ThisView+".isrecon","Field","UpdateName","mc!pbrmain.isrecon")
DBSetProp(ThisView+".isrecon","Field","KeyField",.F.)
DBSetProp(ThisView+".isrecon","Field","Updatable",.T.)

DBSetProp(ThisView+".reconwork","Field","DataType","I")
DBSetProp(ThisView+".reconwork","Field","UpdateName","mc!pbrmain.reconwork")
DBSetProp(ThisView+".reconwork","Field","KeyField",.F.)
DBSetProp(ThisView+".reconwork","Field","Updatable",.T.)

DBSetProp(ThisView+".refundrecon","Field","DataType","L")
DBSetProp(ThisView+".refundrecon","Field","UpdateName","mc!pbrmain.refundrecon")
DBSetProp(ThisView+".refundrecon","Field","KeyField",.F.)
DBSetProp(ThisView+".refundrecon","Field","Updatable",.T.)

DBSetProp(ThisView+".excludewc","Field","DataType","L")
DBSetProp(ThisView+".excludewc","Field","UpdateName","mc!pbrmain.excludewc")
DBSetProp(ThisView+".excludewc","Field","KeyField",.F.)
DBSetProp(ThisView+".excludewc","Field","Updatable",.T.)

DBSetProp(ThisView+".excludeppo","Field","DataType","L")
DBSetProp(ThisView+".excludeppo","Field","UpdateName","mc!pbrmain.excludeppo")
DBSetProp(ThisView+".excludeppo","Field","KeyField",.F.)
DBSetProp(ThisView+".excludeppo","Field","Updatable",.T.)

DBSetProp(ThisView+".firstedit","Field","DataType","L")
DBSetProp(ThisView+".firstedit","Field","UpdateName","mc!pbrmain.firstedit")
DBSetProp(ThisView+".firstedit","Field","KeyField",.F.)
DBSetProp(ThisView+".firstedit","Field","Updatable",.T.)

DBSetProp(ThisView+".oktoeditlines","Field","DataType","L")
DBSetProp(ThisView+".oktoeditlines","Field","UpdateName","mc!pbrmain.oktoeditlines")
DBSetProp(ThisView+".oktoeditlines","Field","KeyField",.F.)
DBSetProp(ThisView+".oktoeditlines","Field","Updatable",.T.)

DBSetProp(ThisView+".drg","Field","DataType","C(5)")
DBSetProp(ThisView+".drg","Field","UpdateName","mc!pbrmain.drg")
DBSetProp(ThisView+".drg","Field","KeyField",.F.)
DBSetProp(ThisView+".drg","Field","Updatable",.T.)

DBSetProp(ThisView+".hospdays","Field","DataType","N(3)")
DBSetProp(ThisView+".hospdays","Field","UpdateName","mc!pbrmain.hospdays")
DBSetProp(ThisView+".hospdays","Field","KeyField",.F.)
DBSetProp(ThisView+".hospdays","Field","Updatable",.T.)

DBSetProp(ThisView+".opposaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".opposaved","Field","UpdateName","mc!pbrmain.opposaved")
DBSetProp(ThisView+".opposaved","Field","KeyField",.F.)
DBSetProp(ThisView+".opposaved","Field","Updatable",.T.)

DBSetProp(ThisView+".fpposaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fpposaved","Field","UpdateName","mc!pbrmain.fpposaved")
DBSetProp(ThisView+".fpposaved","Field","KeyField",.F.)
DBSetProp(ThisView+".fpposaved","Field","Updatable",.T.)

DBSetProp(ThisView+".oppopssaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".oppopssaved","Field","UpdateName","mc!pbrmain.oppopssaved")
DBSetProp(ThisView+".oppopssaved","Field","KeyField",.F.)
DBSetProp(ThisView+".oppopssaved","Field","Updatable",.T.)

DBSetProp(ThisView+".fppopssaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fppopssaved","Field","UpdateName","mc!pbrmain.fppopssaved")
DBSetProp(ThisView+".fppopssaved","Field","KeyField",.F.)
DBSetProp(ThisView+".fppopssaved","Field","Updatable",.T.)

DBSetProp(ThisView+".opssaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".opssaved","Field","UpdateName","mc!pbrmain.opssaved")
DBSetProp(ThisView+".opssaved","Field","KeyField",.F.)
DBSetProp(ThisView+".opssaved","Field","Updatable",.T.)

DBSetProp(ThisView+".fpssaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fpssaved","Field","UpdateName","mc!pbrmain.fpssaved")
DBSetProp(ThisView+".fpssaved","Field","KeyField",.F.)
DBSetProp(ThisView+".fpssaved","Field","Updatable",.T.)

DBSetProp(ThisView+".owccsaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".owccsaved","Field","UpdateName","mc!pbrmain.owccsaved")
DBSetProp(ThisView+".owccsaved","Field","KeyField",.F.)
DBSetProp(ThisView+".owccsaved","Field","Updatable",.T.)

DBSetProp(ThisView+".fwccsaved","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fwccsaved","Field","UpdateName","mc!pbrmain.fwccsaved")
DBSetProp(ThisView+".fwccsaved","Field","KeyField",.F.)
DBSetProp(ThisView+".fwccsaved","Field","Updatable",.T.)

DBSetProp(ThisView+".ototbill","Field","DataType","N(9,2)")
DBSetProp(ThisView+".ototbill","Field","UpdateName","mc!pbrmain.ototbill")
DBSetProp(ThisView+".ototbill","Field","KeyField",.F.)
DBSetProp(ThisView+".ototbill","Field","Updatable",.T.)

DBSetProp(ThisView+".ftotbill","Field","DataType","N(9,2)")
DBSetProp(ThisView+".ftotbill","Field","UpdateName","mc!pbrmain.ftotbill")
DBSetProp(ThisView+".ftotbill","Field","KeyField",.F.)
DBSetProp(ThisView+".ftotbill","Field","Updatable",.T.)

DBSetProp(ThisView+".onumlines","Field","DataType","N(3)")
DBSetProp(ThisView+".onumlines","Field","UpdateName","mc!pbrmain.onumlines")
DBSetProp(ThisView+".onumlines","Field","KeyField",.F.)
DBSetProp(ThisView+".onumlines","Field","Updatable",.T.)

DBSetProp(ThisView+".fnumlines","Field","DataType","N(3)")
DBSetProp(ThisView+".fnumlines","Field","UpdateName","mc!pbrmain.fnumlines")
DBSetProp(ThisView+".fnumlines","Field","KeyField",.F.)
DBSetProp(ThisView+".fnumlines","Field","Updatable",.T.)

DBSetProp(ThisView+".orecpay","Field","DataType","N(9,2)")
DBSetProp(ThisView+".orecpay","Field","UpdateName","mc!pbrmain.orecpay")
DBSetProp(ThisView+".orecpay","Field","KeyField",.F.)
DBSetProp(ThisView+".orecpay","Field","Updatable",.T.)

DBSetProp(ThisView+".frecpay","Field","DataType","N(9,2)")
DBSetProp(ThisView+".frecpay","Field","UpdateName","mc!pbrmain.frecpay")
DBSetProp(ThisView+".frecpay","Field","KeyField",.F.)
DBSetProp(ThisView+".frecpay","Field","Updatable",.T.)

DBSetProp(ThisView+".olinecharge","Field","DataType","N(6,2)")
DBSetProp(ThisView+".olinecharge","Field","UpdateName","mc!pbrmain.olinecharge")
DBSetProp(ThisView+".olinecharge","Field","KeyField",.F.)
DBSetProp(ThisView+".olinecharge","Field","Updatable",.T.)

DBSetProp(ThisView+".flinecharge","Field","DataType","N(6,2)")
DBSetProp(ThisView+".flinecharge","Field","UpdateName","mc!pbrmain.flinecharge")
DBSetProp(ThisView+".flinecharge","Field","KeyField",.F.)
DBSetProp(ThisView+".flinecharge","Field","Updatable",.T.)

DBSetProp(ThisView+".oppocharge","Field","DataType","N(9,2)")
DBSetProp(ThisView+".oppocharge","Field","UpdateName","mc!pbrmain.oppocharge")
DBSetProp(ThisView+".oppocharge","Field","KeyField",.F.)
DBSetProp(ThisView+".oppocharge","Field","Updatable",.T.)

DBSetProp(ThisView+".fppocharge","Field","DataType","N(9,2)")
DBSetProp(ThisView+".fppocharge","Field","UpdateName","mc!pbrmain.fppocharge")
DBSetProp(ThisView+".fppocharge","Field","KeyField",.F.)
DBSetProp(ThisView+".fppocharge","Field","Updatable",.T.)

DBSetProp(ThisView+".compsaved","Field","DataType","N(10,2)")
DBSetProp(ThisView+".compsaved","Field","UpdateName","mc!pbrmain.compsaved")
DBSetProp(ThisView+".compsaved","Field","KeyField",.F.)
DBSetProp(ThisView+".compsaved","Field","Updatable",.T.)

DBSetProp(ThisView+".addlpymt","Field","DataType","N(8,2)")
DBSetProp(ThisView+".addlpymt","Field","UpdateName","mc!pbrmain.addlpymt")
DBSetProp(ThisView+".addlpymt","Field","KeyField",.F.)
DBSetProp(ThisView+".addlpymt","Field","Updatable",.T.)

DBSetProp(ThisView+".addlpymtreason","Field","DataType","M")
DBSetProp(ThisView+".addlpymtreason","Field","UpdateName","mc!pbrmain.addlpymtreason")
DBSetProp(ThisView+".addlpymtreason","Field","KeyField",.F.)
DBSetProp(ThisView+".addlpymtreason","Field","Updatable",.T.)

DBSetProp(ThisView+".chargeerrors","Field","DataType","N(10,2)")
DBSetProp(ThisView+".chargeerrors","Field","UpdateName","mc!pbrmain.chargeerrors")
DBSetProp(ThisView+".chargeerrors","Field","KeyField",.F.)
DBSetProp(ThisView+".chargeerrors","Field","Updatable",.T.)



>Hmmmm...
>
>Can't find any bugs in our database related to this and I also can't repro using any of the tables or view from the Northwind database. Ummm...there should be spaces between the end of the lines and the semi-colon but that's probably just the way it went into this post?
>
>Could you go to the VD, right-click to pull up SQL, and cut and paste the exact SQL? Thanks.
>
>
>
>>I'm trying to upgrade my app to VFP9 from VFP8. It's giving me the "SQL expression is too complex" on this view:
>>
>>SELECT *;
>> FROM ;
>> mc!pbrwork ;
>> INNER JOIN mc!pbrmain ;
>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>>
>>Any ideas?