How do I create a one on one relationship between fields in different tables?
For example I have a table with position numbers. Based on the position number I would like to auto-insert a job title in the job title field on a different table.
Novice
Windows 7 64bit 
Access 2010 64bit
How do I create a one on one relationship between fields in different tables?
For example I have a table with position numbers. Based on the position number I would like to auto-insert a job title in the job title field on a different table.
VIP
Windows XP Access 2010 32bit
The job title is in the table with position numbers? Should not save the job title in the other table, just the record ID or position number if that is the primary key from the position table. Then when you join the tables can refer to the job title field to display in forms and reports.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
THat makes sense but I can't get it to work. I guess I don't understand how to use access.
VIP
Windows XP Access 2010 32bit
Need to understand relational database concepts, regardless of the application (SQL, Oracle, dBase). Once that is mastered, building tables according to those concepts is simple. Check this site, review the 'sticky' thread tutorials at the top of forum http://forums.aspfree.com/microsoft-access-help-18/
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Relationships again
Too Many Relationships
Posting Permissions
Reply With Quote