>I have a things table and a documents table, related many to many with a common child table called thingdocs. What is the best view to use for a report listing the documents for each thing, or the things for each document? I haven't tried using parameterized views with a report before. I wasn't sure if it was best to make one big view containing everything, or two separate views, with one parameterized, or what. Thank you.
Actually, it's much simpler to use Select.. Into Cursor. Views will be obvious overhead because you don't need in buffering,tableupdating,etc for report purposes.
Edward Pikman
Independent Consultant