Electronic Approval

[Mr2006]

I need to create a query to obtain manager approval. We have several managers in our office and each manager has several staff who request several payments to several vendors. I created a query that the managers can run with parameter to show the records that his staff entered so he can approve. I want when the manager enter passcode to run the query, it shows only the records relating to his department and in the approval combobox where it shows all the manager, it filter to only his name. This way he can not see other department record and can not choose someone else to approve payments.

in summary, the query has to do the following:
1) When manager run the query, it only shows his records.
2) after the query run, the approval combobox will only shows the same manager name to choose if he approves.

Any suggestions!!

Thanks

 

[SkipVought]

What do you have so far?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Mr2006]

I have not done anything for the manager approval part. But I am able to filter per the department using parameters. The table has two field for manager. One managedby which the paramter is built on and this field is completed by the staff. The second one in the approvedBy whcih is the one that I need to have the manager only able to complete

 

[SkipVought]

Well it would seem to me that, at a minimum, you'd have a FORM, where the manager could check the row(s) to approve, a button to toggle clear all/check all checkboxes and a button to submit the approval for all checked rows.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Mr2006]

I was thinking that would be step 2. I thought I should get the query running right first.

 

[SkipVought]

"I thought I should get the query running right first."

Well is it? If not, what help do you need?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Mr2006]

How can I have the perameter when when opening the query filter for the manager records and also filter the combobox to show his name only?

 

[Remou]

It is nearly always a good idea to post your SQL.

 

[lespaul]

and you should check out faq701-6763

Leslie

Have you met Hardy Heron?