i have a VFP .dbc that has normalized tables. some of the tables have as many as 30 FK's.

i am trying to create views from these tables and have run into limiltatins on how many joins i can have in a single select statement. through trial and error, i discovered that this limit is 8 joins.

so far, i have gotten around this by creating multiple views. and i know that i can join all of these smaller views into a single view to get the end result that i want.

i am curious to know if this approach is appropriate or if there is some other way to do this. i am concerned that this approach may lead to performance problems down the road when i have lots-o-data in the tables.

thanks, pbd