Computer Skills & Shortcuts : How to Add a One-to-Many Database Relationship in Microsoft Access

Adding a one-to-many database relationship in Microsoft Access involves many steps using the Tools and Relationships menus but is a simple process. Create database relationships in Microsoft Access with an IT specialist in is free video on computer software.

Expert: Dave Andrews
Contact: www.daveandrews.org
Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department.
Filmmaker: Tim Brown

Category:

Science & Technology

Tags:

• computers
• computing
• computer help
• computer skills
• troubleshooting
• computer hardware
• computer software

[RNLarkin]

Does anyone know how I can make fields autopopulate based on one field.

EX: Stududent Number is 1234 so access autopopulates that the student's name is John Smith and hes in the 11 grade, etc. any help would be MUCH appreciated. THANKS

[realseoul]

you created a one-to-one relationship dude.  look at your computer screen and read.

[ToxiC022]

you need to create third field in the Table2 to be linked with the ID from Table1. ie: --------- Table1 Field name | DataType ID1 Autonumber (best for ID fields) MyData1 Text Table2 Field name |  DataType ID2 Autonumber (best for ID fields) MyData2 Text IDTable1 Number (same type as linked field from Table1) than in relationship screen drag field ID1 from Table1 to IDTable1 at Table2 ...

[beatified]

If you watch the video closely you can see that when he creates the relationship it actually says one-to-one. He did this incorrectly.

[jimaginator]

Hi Dave: I got a one-to-one relationship whether I went from table 1 to table 2 or went from table 2 to table 1. I haven't found any instructions anywhere that have given me a successful outcome. Very frustrating.