I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields.
I may have to revert to logical files, settll/reade and chains to get this done. I hate to. Sql does the selecting so nicely when you figure out how to make it work with each scenario.
Any pointers out there on the Create View? In the process, where does it go? On the Select statement or when setting up the cursor or somewhere else?
I don’t know much about this but enough to not to try a Update or Delete with SQL yet. LOL.