automatically populate field sequentially from list

45 pts.
Tags:
Database
I created a form for assigning incoming projects to employees. I have a main table that includes the majority of the data relevant to the project and I have another table with just the employee’s names, work unit, and an auto id field. The main table also has the employee’s name and work unit. I would like to set up the form (maybe a macro??) so that when a new entry is made the employee name is automatically selected sequentially from the table, and added to the form. Is this possible?

Answer Wiki

Thanks. We'll let you know when a new response is added.

thank you for responding. i’m sorry, this is the first time i’ve actually been on a site like this and i’m actually new to Access. i’ve never received training but i do ok developing simple databases.
I’m using Access 2003. i created a table for the employee and unit because i thought that giving it an auto id might help with the auto population. what i’m trying to do is this –
when a new case comes in its added to the database and includes the date received, date due, case number, employee and unit. i would like the employee and unit to fields to be populated automatically. to be fair, the cases must be sequentially assigned so that one person doesn’t get 5 cases and the next only 1. so i would like the employee assignment to be based on the list and entered one right after the other.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Yes, it is possible, but you might want to provide more details. -What database platform (and version) are you using (I assume it is Access, but need confirmation) are you using ? -Why do you have employee names and work units in both tables (that's redundant, and could be a sign of poor database design) ? -What do you mean by "is automatically selected **sequentially** from the table" ?
    69,920 pointsBadges:
    report
  • Jodibelle
    thank you for responding. i'm sorry, this is the first time i've actually been on a site like this and i'm actually new to Access. i've never received training but i do ok developing simple databases. I'm using Access 2003. i created a table for the employee and unit because i thought that giving it an auto id might help with the auto population. what i'm trying to do is this - when a new case comes in its added to the database and includes the date received, date due, case number, employee and unit. i would like the employee and unit to fields to be populated automatically. to be fair, the cases must be sequentially assigned so that one person doesn't get 5 cases and the next only 1. so i would like the employee assignment to be based on the list and entered one right after the other.
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following