Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement