Northwind

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using northwinds and my teacher wants us to explain the relationships
between each query (individually). Example Query: Alphabetical list of
products, this query has two tables Catergories and Products Now I see that
these two tables have a relationship, how do I explain a one to many
relationship without saying one-to-many. What are the two tables connected by
that line really saying??...(Lets say if I were trying to explain it to
someone who didnt have a clue what they were looking at.)
 
Simply that a given product, in Products, must have its category present in
table Categories AND that a given category can be shared by many products
in Products (or, said differently, that many different products can have
the same category value).


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query for Subform Needed Please 4
Can't edit my query 2
Query shows no results when using 2 tables with multiple relations 3
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Query joins not created in front end query grid 2
Query based on two unrelated tables 2
ConcatRelated 0
Can I edit data in a query with a one-to-many relationship (2000) 1

Back
Top