I haven't really planned out all the child types, yet, so I'm not sure how similar they would be. Actually, their similarity depends a lot on which route I take. :) If I put them in one table, I'll make them really similar.

Thanks,

Michelle


>Is there any similarity between the different child types? In other words, would any of the different child recrods use the same fields?
>
>I think I would lean more toward one child table, and add a new table named ChildTypes. Each child record would have a foreign key from the ChildTypes table. If a new child type is needed, you can simply add a record to the ChildTypes table. This will also makes your views of the data easier. No need to worry about joining sibling tables.
>
>This would leave you with blank fields in the child table for different ChildTypes, but who cares, disk space is cheap *g*? And besides, Fox already does this with their *.frx tables.