D/SIRS

I am eager to go to the next level.

I got it all sorted out about staff table, then staff with products, then with sales reports; staff with duties for emergencies etc. So far so good.

Now I am bit eager to find out a way to do the following:

I have staff-table and job-table.

I have an input form to enter new staff and their details.

I am trying to automate it and this is where I am stuck now.

For example I get the staff ranks auto inserted based on their priority number.

In the same manner I want to insert the job-code inserted automatically.

Two issues cropped up.



1. I have only staff-table as control source. I might have to link both staff table and job-table so that I can get that job-code from that table but dont think it will update.

2. Some times there will be three staff with same rank. If so, I have to make the job-code to be picked for the one below the first staff with same rank.

Do not want to over explain and confuse. Pls guide me and will explain further on asking for it.

brgds/captgnvr