Union Query Dilemma

[usfarang]

I use a union query as the record source to select a employee type. They are either an employee or a non-employee. I also use a combo to select the type of payroll, i.e. Payroll or Non-Payroll.
If the employee type is Non-Employee then I don't want them to be able to issue a payroll check, just a miscellaneous check.
The combo to select an employee type uses the union query so you get both types. I am attaching some screenshots that hopefully will help.
Hope this makes sense.

Thanks,

[usfarang]

Not sure how to address this. I know I need to add something like a true false field to the union query but I decided on a different route. It was setup this way many years ago and I'm reworking it.
I will just add another table tblEmployeeType and go from there. However if anyone knows of an easy fix, please leave a comment.

Thanks,

[Welshgasman]

And the question is?
Why the need for a union query? Surely a status in the Personnel file (called Employee) would be better?

[orange]

Why choose both types in the combo? Why not a option for Select Employees OR Select NonEmployees; then use the response to populate the combo as appropriate.

[usfarang]

As I said, this was an old db that I was re-working. It was setup that way. Thanks for the suggestions. Like I said, I went with just a simple combo, employee/non employee selection. Not that a union query was a bad option, just difficult to implement in some cases.
Thanks

[Welshgasman]

Crossposted and posted first at https://eileenslounge.com/viewtopic.php?f=29&t=37836

[usfarang]

Yes I did post there first and did not get a workable solution and although it is NOT my custom and was a one off, I make no apologies. A post was made before I could come back and view it although it was not workable for me.
Not here to waste anyone's time but things happen sometimes. I made an apology to the replier and this is finished in my book.
Have a Good Day.

[orange]

Glad you have resolved your issue.

No one is asking for an apology. The forum participants (this forum and others) generally follow this etiquette when cross-posting:
- indicate that they have posted in one or more forums,
- identify the url(s) of the cross post(s),
- reply in the cross post(s) if a solution has been found.

Crossposters are often directed to this Excelguru reference for guidance/enlightenment and rationale.

For example, in this forum https://www.accessforums.net/showthr...ight=excelguru