how do you relete the tables in base
Answers
The aim of relationships is to ensure the integrity of the data stored in related tables of a single database. It's important to keep the terminology straight. Think of it this way (the analogy is limited, and will only help so far, though!). Your database is like a bookcase, your tables are like the shelves, and the fields in the tables like the books, magazines (different types) on the shelves. One bookcase has some/many shelves, each shelf has numbers of books (which contain your information). One database has some/many tables, each table has numbers of fields (which contain your information). Back to relations, then. In a relational database, the "1:many", "1:1", etc., relations connect fields in different tables. An example. Let's stick with the library analogy. Say we have a database for our library collection. Two of our tables would be "Authors" and "Books": Table:Authors / Fields: AuthorID, Author_LastName, Author_FirstName, Author_DoB Table:Books / Fields: BookID, Title, PubDate, Publisher, Location