General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Terry:
I agree that, in a One-to-Many Relation, the Child table should be the "Many". In your example, it would be the Address table. If I reverse the Relation, then I would need a Filter (or keep it Indexed and constantly use WHILE) to isolate one county or state. If I were only interested in New York, for example, I would still get every Child record unless I Filtered or used WHILE).
I think that my problem is caused by a FoxPro bug, and I developed a workaround by using SEEKs and SCAN FORs. So far, so good. After knocking my brains out (and those of everyone here) all week, I am ready to celebrate.
Jerry
Previous
Next
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