posted in forms because i think the answer *might* involve using a form to pass the parameter, but point me in another direction if you think i'm in the wrong place-
is it possible to have one parameter prompt for entry do two things?
i have a db that creates a table whose data will eventually be appended to another table in another db. i need to add the table name to each record in the table, so that once the data is in the other db it can easily be linked via an existing field in the new db. i know i CAN do this by requesting a parameter in an update query and then prompting the user to "save as" and type the same entry again, but i'd rather do it in one fell swoop.
thanks experts-
is it possible to have one parameter prompt for entry do two things?
i have a db that creates a table whose data will eventually be appended to another table in another db. i need to add the table name to each record in the table, so that once the data is in the other db it can easily be linked via an existing field in the new db. i know i CAN do this by requesting a parameter in an update query and then prompting the user to "save as" and type the same entry again, but i'd rather do it in one fell swoop.
thanks experts-
