N
Norman Fritag
Hi there,
I have inherited a database that has a form, which uses 2 dropdown listboxes
to drilldown and finding a specific record in the form. (Plus, I am not very
familiar with the system.)
The Search / find logic is based on a 3 levels: level1 = Maintopic, Level 2
= Subtopic , 3rd level = Questions.
The Form displays only the questions in relation to a subtopic. There may
be several Question to a Subtopic.
Now, if I want to add a new question, the program (as is) adds the question
into the remainder of all other question ( = 250),( or rows of that table.)
Obviously, I would expect to see only a record count of 8 records, if there
were 8 questions in relation to the subtopic.
What I like to see after a new question was added is that the form displays
only records relevant to the Subtopic, with the new question the main focus
ready for data entry.
I thought to using the "domd.findrecord someid,,true,,true,
accurrent,true" to filter on the Subtopic's Id Number, to get all relevant
records, but then I am not clear as to how I am get the current record,
which has the newly added Question displayed ,ready for the user to enter a
new question.
I mean the other option could be to use the subtopic I d number in the
Underlining query as a filter, but I can't answer if that is the way to got
at this stage.
What other option do I have? Any other suggestions are most welcome.
Kind regards
Norman F
I have inherited a database that has a form, which uses 2 dropdown listboxes
to drilldown and finding a specific record in the form. (Plus, I am not very
familiar with the system.)
The Search / find logic is based on a 3 levels: level1 = Maintopic, Level 2
= Subtopic , 3rd level = Questions.
The Form displays only the questions in relation to a subtopic. There may
be several Question to a Subtopic.
Now, if I want to add a new question, the program (as is) adds the question
into the remainder of all other question ( = 250),( or rows of that table.)
Obviously, I would expect to see only a record count of 8 records, if there
were 8 questions in relation to the subtopic.
What I like to see after a new question was added is that the form displays
only records relevant to the Subtopic, with the new question the main focus
ready for data entry.
I thought to using the "domd.findrecord someid,,true,,true,
accurrent,true" to filter on the Subtopic's Id Number, to get all relevant
records, but then I am not clear as to how I am get the current record,
which has the newly added Question displayed ,ready for the user to enter a
new question.
I mean the other option could be to use the subtopic I d number in the
Underlining query as a filter, but I can't answer if that is the way to got
at this stage.
What other option do I have? Any other suggestions are most welcome.
Kind regards
Norman F