General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only