C
complex
Greetings to everyone!
My situation is this, my database creates a work order with some tasks, that
may or may not be accomplished. I have a query that retrieves the tasks
present on a selected work order, (those tasks come from a table called
taskstbl, and this table does not have a check box field), my objective is to
verify the tasks that appear on the results of that query, and check the
tasks that were accomplished and add (append query) them to the work order
record (something like workorderdetailstbl). So what I want to know is, can't
I add a check box "field" to the query so that the append query "knows" what
to add to the workorderdetailstbl? The check box would only have a temporary
utility...if I may call it like this. Is it really necessary to have the
check box field on the original table? Or can I just add the checkbox field
to the query as an expression?
My situation is this, my database creates a work order with some tasks, that
may or may not be accomplished. I have a query that retrieves the tasks
present on a selected work order, (those tasks come from a table called
taskstbl, and this table does not have a check box field), my objective is to
verify the tasks that appear on the results of that query, and check the
tasks that were accomplished and add (append query) them to the work order
record (something like workorderdetailstbl). So what I want to know is, can't
I add a check box "field" to the query so that the append query "knows" what
to add to the workorderdetailstbl? The check box would only have a temporary
utility...if I may call it like this. Is it really necessary to have the
check box field on the original table? Or can I just add the checkbox field
to the query as an expression?