Hi John.

>> When I use the KeyFieldList property on the Invoice table, I get another error message. <<

What is the error message?

>> can't use the view designer because I am limited to three tables. <<

So? It does not matter how many tables you have. The view designer handles straight parent -> child -> grandchild relationships with no problem regardless of the number of tables (although I believe that you are limited to a maximum of nine joins. The problem with the view designer is that it doesn't handle more that two unrelated siblings because of the nested syntax that it uses.

Marcia