General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Terry:
My show on Saturday night went well, and I met some celebs.
"> Not bad, but my policy is to use only my own stuff."
"Yes I know that but who's to know? The more gags the merrier."
I would know.
The Brighton Comedy Festival sounds like a good idea. I have to see if I can get time off from my day job (software engineer), though.
BTW, I am having a similar problem to the one that started this post. I have set a relation between two tables (one to many), but the relation doesn't seem to work until I browse the parent table. However, since I need the data to appear on pages in a pageframe, I don't want to browse the table. Any ideas? My code is:
SELECT Child
SET ORDER TO ChildIndex
SET RELATION TO KeyField2 INTO GrandChild, KeyField3 INTO GrandChild2
SELECT Parent
SET RELATION TO KeyField INTO Child
SET SKIP TO Child
SET ORDER TO ParentIndex
SEEK ThisForm.KeyValue IN Parent
I have other relations going on that I didn't list, but they don't involve the relation between Parent and Child, which is where I'm having the problem.
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