J
jackle
I have a need to create a comment field for a recordset. i figured i could
create a small table for this called tblUserComments. It has 2 fields,
WorkOrder (primary keyy, text field) and Comments (memo field). The WorkOrder
field matches a work order in the recordset query. This query is displayed in
a tabular form with the Comments field at the end. How can i backflush the
Comments AND the WorkOrder if it doesn't exist? Since most of the work orders
won't have a comment, i'd hate to send all work orders to this table without
a way to purge these work orders when completed. any ideas. If you can, be as
explicit as possible.
thanks,
Jackle
create a small table for this called tblUserComments. It has 2 fields,
WorkOrder (primary keyy, text field) and Comments (memo field). The WorkOrder
field matches a work order in the recordset query. This query is displayed in
a tabular form with the Comments field at the end. How can i backflush the
Comments AND the WorkOrder if it doesn't exist? Since most of the work orders
won't have a comment, i'd hate to send all work orders to this table without
a way to purge these work orders when completed. any ideas. If you can, be as
explicit as possible.
thanks,
Jackle