hortense76
Registered User.
- Local time
- Today, 17:35
- Joined
- Mar 16, 2006
- Messages
- 21
I have a Form and a all-records-view Subform each based on tables "Chapters" and "Paragraphs"
In Chapter (and Form) I have a field "ParagraphID" which relates to the 1st paragraph of current Chapter. Then field HowManyParags gives the number of paragraph of this very Chapter.
Basically I can easily sort paragraphs by page number (as I did), but now I just want to show PragraphID-related paragraph AND next (HowManyParags-1) paragraphs in my subform (only for display purpouse).
Yes I know things were done opposite of common sense (there should have been a ChapterID field in "Paragraphs" and all relationships would have been clear!) but I had good reasons 
not to do it.
Anyway this shouldn't be so difficoult but I went crazy by serializing (with Leban's function) my Paragraphs query and so on but I failed... please: is there any way to ask the subform to show THAT record AND next n records? It MUST be simple!
Thank you!
In Chapter (and Form) I have a field "ParagraphID" which relates to the 1st paragraph of current Chapter. Then field HowManyParags gives the number of paragraph of this very Chapter.
Basically I can easily sort paragraphs by page number (as I did), but now I just want to show PragraphID-related paragraph AND next (HowManyParags-1) paragraphs in my subform (only for display purpouse).
Yes I know things were done opposite of common sense (there should have been a ChapterID field in "Paragraphs" and all relationships would have been clear!) but I had good reasons not to do it.Anyway this shouldn't be so difficoult but I went crazy by serializing (with Leban's function) my Paragraphs query and so on but I failed... please: is there any way to ask the subform to show THAT record AND next n records? It MUST be simple!
Thank you!
