Many to Many Relationships

From: Lynn (anonymous_at_discussions.microsoft.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 10:23:52 -0700

Good morning. I am new to Access databases and to date I
have done a considerable amount of research and reading
but am unable to ensure the steps I am taking in the set
up of the tables will work as I design the forms and
reports. I have set up tables for Customers that will
link to Quotes and Jobs. Quotes and Jobs both have sub
tables linking to details that will be used for line
items.

To this point I have inserted two tables for
Customer/Quotes and another for Customer/Jobs which if I
understand correctly will link the Customers with Jobs
and Quotes. I can have many Customers that may have many
quotes or many jobs.

I understand how the set up of the tables is vital for
the database to work correctly.

This is the first step and once I know I have done this
correctly I need to understand how I use the tables
created to set up my forms.

Thank you in advance for any assistance you can provide
to help me to go on from this point.

Relevant Pages

  • Re: Many to Many Relationships
    ... up a combined primary key with the primary keys from the ... I need to be able to track all Quotes and there ... I have Customers that may have Quotes and Jobs and I may ...
    (microsoft.public.access.tablesdbdesign)
  • More assistance with Many to Many Relationships
    ... up a combined primary key with the primary keys from the ... I need to be able to track all Quotes and there ... I have Customers that may have Quotes and Jobs and I may ...
    (microsoft.public.access.tablesdbdesign)
  • Re: More assistance with Many to Many Relationships
    ... The quote could definitely lead to multiple jobs. ... to link the Customers to both Quotes and Jobs. ... >> I have Customers that may have Quotes and Jobs and I ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Please suggest relationships model
    ... Providing Customers A Resource For Help With Access, ... However, if he wanted his database quick and painless, I provided ... Here you are in the newsgroup offering services that were NOT ASKED for. ... the newsgroups and a few larger jobs. ...
    (microsoft.public.access.queries)
  • Re: CursorAdapter, MySQL - View definition has been changed.
    ... I have 3 grids ... Customers have many parts, parts have many quotes. ... I am not sure what is causing this error. ...
    (microsoft.public.fox.programmer.exchange)
Loading