M
mcnews
i have a continuous form that is bound to a distinct row view that
populates some of the fields.
two of the fields must consist of a record count from one of the
tables in the view.
based on the key field of the view the count looks for a value in one
of the fields in the under-lying table.
i would like to know the best way to get this count and display it in
the field of the continuous form.
so the row looks something like:
KeyID DateRcvd Description CountOfRowsForKeyID1
CountOfRowsForKeyID2 Unique Comments RprtDat
i also need to scan a 20 character comment field in the same table and
display the unique comments in one larger field.
i am wondering if i need to do some preprocessing to store all of this
in a temp table whenever the form is opened.
i'd appreciate any ideas on this one.
tia,
mcnewsxp
populates some of the fields.
two of the fields must consist of a record count from one of the
tables in the view.
based on the key field of the view the count looks for a value in one
of the fields in the under-lying table.
i would like to know the best way to get this count and display it in
the field of the continuous form.
so the row looks something like:
KeyID DateRcvd Description CountOfRowsForKeyID1
CountOfRowsForKeyID2 Unique Comments RprtDat
i also need to scan a 20 character comment field in the same table and
display the unique comments in one larger field.
i am wondering if i need to do some preprocessing to store all of this
in a temp table whenever the form is opened.
i'd appreciate any ideas on this one.
tia,
mcnewsxp