Hi Aaron,
The query builder to generate joins that you mentioned is exactly what I
am going to do doing this time. That is one of the reasons I have the
generic field names for the primary and foreign key fields. Then I only
have to pass the search criteria the table names and which direction I
want to do the joins.
Thanks again for your help.
Regards
John T
Aaron Bono wrote:
> We all find ourselves in different situations and because of that,
> what works for one person, doesn't work for another - so I
> understand. Good luck with the application and future queries. Maybe
> you can use the existing structure of your application to help create
> a query builder so you can have it write a lot of your joins for you.
> That should help avoid a lot of simply typos or mix-ups when hand
> writing your queries.
>
> I am glad the queries worked for you.
>
> -Aaron