>
>Knowing that three tables in a view does not work. would the correct approach be as follows:
>
NOt quite sure what you're asking here, but I have to ask about your statement above.
Three tables in a view does not work woth the view designer, but that does not mean you cannot create these views with code.
CREATE SQL VIEW myView AS;
SELECT table1.field, table2.field2, table3.field3;
FROM table1. table2, table3;
WHERE table1.pk = table2.fk AND;
table2.pk = table3.fk
You only have to run code like this once, and the view is created in the dbc just like it would be in the view designer. But you can't edit it in the view designer.
Knowing this, has your report question changed?
Erik Moore
Clientelligence