Automatically updating info in tables

[skgolden]

Thanks to this forum, I was FINALLY able to create an employee
scheduling database on Access 97 having zero experience doing this
kind of thing. Now that I'm about 95% there, I have two final issues.

We have a temporary labor company. The three primary tables that I
used are a) one with all the client/unit location information; b) one
with the employee name and their status (active or inactive) and c)
the skill level required for the job. From this I created a 4th table
and accompanying form that incorporates all this data to generate a
daily report of who is scheduled to go where the following day. So
here are my two problems:

1. As this is a temporary labor company, employees regularly come and
go and come back again. What do I need to do to make sure that if I
enter an employee's name on the scheduling form and that name is not
already on the employee table that it will automatically update the
employee table by adding that employee's name?

2. After I run my scheduling report for tomorrow's schedule, how do I
then run a report that shows ONLY active employees who are NOT already
assigned for the next day so we know what's left in the pool to choose
from as jobs becomes available.

Again, thanks for all the help in getting me this far! If anyone can
recommend a good book or training dvd on Access 97 for realllllll
dummies, please let me know!

sk*******@yahoo.com

[Bas Cost Budde]

skgolden wrote:

1. As this is a temporary labor company, employees regularly come and
go and come back again. What do I need to do to make sure that if I
enter an employee's name on the scheduling form and that name is not
already on the employee table that it will automatically update the
employee table by adding that employee's name?
Suppose you select the employee from a combobox. If you set the
LimitToList property (to true), and the user--you?--enters a name that
is not in the list, the NotInList event fires. You can do what it takes
to add your new employee, the name entered is in the NewData parameter
for the event; after you've done, set the Response parameter to
acDataErrAdded
2. After I run my scheduling report for tomorrow's schedule, how do I
then run a report that shows ONLY active employees who are NOT already
assigned for the next day so we know what's left in the pool to choose
from as jobs becomes available.

See if the Unmatched query wizard helps you in the right direction, to
solve the "not assigned" part. I suppose you figured out how to filter
on 'active'.

I'd be glad to provide more detailed instructions if you need them, but
I must know a little more of your data structure then. Where the
assignments are stored, names of this table (I presume it's a table).
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea