OutPut of quries1 = Input into Quries2 (1 Viewer)

[edisonl]

Hi everyone,

Background:
Am developing leave application. Supervisor login> System able to detect any leave awaiting for approval.

My Solution:
- Search by supervisor dept> list out lists of names (this lists are not captured in any particular controls just using normal quries Eg: SELECT blah blah blah.. By blah blah blah... )
- Once having a lists I used this lists of UserID & compared with another table (PendingLeave_Table) to check if their userid exists. If Have activate my controls/ prompt for supervisor approval accordingly.


Questions:
1. Any Ideas what other solution besides mine provides similar results ?
2. Is Union or what other types of quries is appropriate ?

Regards & God Bless, Edison Ler

 

[Pat Hartman]

I don't quite understand your description but queries and tables can be used interchangeably for most things. Create query1 and save it. Then create query2 and select query1 and then join it to a table or another query.

 

[edisonl]

Hi, (Thanks for your reading & reply firstly)

1. Basically Output of qury1 generate lists of names & userid with same department.
2. From the department & userid, lookup another table & check if this names/userid exists.

Table1- Personne_table (Entails>> UserId, Dept, DateOfEmployment, Gender, Names, Nationality,AccessRights)

Table2- LeavePending_Table (Entails>> UserID & Type of Leave)

Functions:
1. Supervisor of Particular Department (Eg: Accounts Login)

2. From Supervisor ID (Eg: 099) System detect its from Accounts Department.

3. System able to prompt Supervisor if any pending leave requires His/Her Approval & Prompt accordingly if it does.

4. Therefore in order to do so DB should be able to retrieve lists of userid from Accounts Department & Lookup PendingLeave_Table. If UserID exists, trigger a prompt to Supervisor whenthey login into Leave Application.


Regards & God Bless, Edison Ler