select which table reports go to from form

[Guest]

I might have already posted this question, but I can't find it, so here's to
the ignorance again.

I have a form based on results from a query. The query basically gives me a
"bad boy" list of people. I would like to have two button options next to
each name in the form. One sends the name to a "waived" table, the other
sends them to the "prosecute" table.

Since the form is based off the query, I don't think I can bind the two
tables to the form. So how can I choose which table the "bad boys" will go to?

 

[John Vinson]

I might have already posted this question, but I can't find it, so here's to
the ignorance again.

I have a form based on results from a query. The query basically gives me a
"bad boy" list of people. I would like to have two button options next to
each name in the form. One sends the name to a "waived" table, the other
sends them to the "prosecute" table.

Since the form is based off the query, I don't think I can bind the two
tables to the form. So how can I choose which table the "bad boys" will go to?

Rather than copying (I presume multiple) fields from one table to
another, might it not be simpler (as well as better normalized!) to
make waiver and prosecution attributes of the person's record? That
is, you could add a Yes/No field Waived and another Prosecute to the
table containing the person's information, and check the appropriate
checkbox.

If one person can be waived in some circumstances, and prosecuted in
another, you may need another table - but having separate tables with
the same fields for the three categories is simply Bad Design!

John W. Vinson[MVP]

 

[Guest]

I've already considered that, but the primary table with all employees is
imported... which can't be altered.

 

[John Vinson]

I've already considered that, but the primary table with all employees is
imported... which can't be altered.

Then add another table with JUST the EmployeeID as a primary key (same
datatype and size as your employee table), and an Integer field with
the value 1 meaning "waive" and 2 meaning "prosecute". Use the
Relationships window to make a one-to-one relationship from this
table's employeeID to the Employee table. Use a Form based on a query
joining the two tables, and use an Option Group control to select the
employee's status.

John W. Vinson[MVP]

 

[Guest]

Man, you totally rock. I hope this wasn't too easy of a question for you.