Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Data Environment Question
Pardon this novice question, but I've worked on this for hours without results.
I have a form with a grid that displays fields from a parent and child table and a one to many relationship.
I want to trigger a search and display the results in the same grid. The search will require changing the relationships, parent and child cursors and change the tag orders.
I've tried using code after the string search:
SELECT clients
set orde to alpha
SELECT Pets
set rela to idno into clients
etc...
Is there a way to programatically change the data environment to accomplish what I want or am I going about it the wrong way?
I hope this makes sense and TIA.
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