KwickClips Databases and SQL · 41 sec · free
Where do you create a relationship?
Short answer. Tools > Relationships.
What must match in the two fields?
The field type.
Three steps
| Tools > Relationships |
| Add both tables |
| Drag key onto key |
Remember
| Same field type needed |
| Line shows 1 and n |
How do you link two tables in Base? Close tables, then three steps. Choose Tools, Relationships. Add both tables. Drag the key onto the matching field. Two checks. Field types must match. The line shows 1 and n.
This clip is from the full lesson: Relationships Between Tables in Base — 7 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 10 Information Technology (402)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.