Reply to thread

Message: [QUOTE="John W. Vinson, post: 12131648"] If you're trying to include both the supervisor ID AND the supervisor name in the worker table... DON'T. It's redundant and unnecessary. In addition, you really should not be looking at (or letting users look at) table datasheets AT ALL. If the table of supervisors has an autonumber ID, it won't be meaningful to the users anyway; you'll be much better off using a Form with a combo box, storing (but concealing) the ID and displaying the supervisor's full name. We're nowhere near doing any programming yet... but you do need to learn how to normalize relational tables. They may look like spreadsheets *but they are different* and require different logic! For some tutorials and suggestions see Jeff Conrad's resources page: [URL]http://www.accessmvp.com/JConrad/accessjunkie/resources.html[/URL] The Access Web resources page: [URL]http://www.mvps.org/access/resources/index.html[/URL] A free tutorial written by Crystal (MS Access MVP): [URL]http://allenbrowne.com/casu-22.html[/URL] MVP Allen Browne's tutorials: [URL]http://allenbrowne.com/links.html#Tutorials[/URL] [/QUOTE]