JeepsR4Mud
Registered User.
- Local time
- Yesterday, 22:11
- Joined
- Sep 23, 2002
- Messages
- 70
I am designing a database, and entry forms concerning some staff issues at work. Each site (33 of them) has to submit a weekly report. What makes each record unique is both the site location and the week.
After thinking about the logistics of trying to always link those two fields, I decided that perhaps it was easier to create a third field, ID that linked the information from the fields INSTITUTION and WEEK (site ID and date identifying the week of the report).
Is there a way to have the data in the ID field, automatically generated after the values for INSTITUTION and WEEK are entered?
I'm trying to reduce key strokes AND make this VERY user friendly.
THANKS so much.
Gayle Ann
After thinking about the logistics of trying to always link those two fields, I decided that perhaps it was easier to create a third field, ID that linked the information from the fields INSTITUTION and WEEK (site ID and date identifying the week of the report).
Is there a way to have the data in the ID field, automatically generated after the values for INSTITUTION and WEEK are entered?
I'm trying to reduce key strokes AND make this VERY user friendly.
THANKS so much.
Gayle Ann