Re: More assistance with Many to Many Relationships

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

Date: Wed, 7 Jul 2004 12:08:22 -0700

Rebecca:

The quote could definitely lead to multiple jobs. I need
to link the Customers to both Quotes and Jobs. I am not
sure I clearly understand how that will work for both
Quotes and Jobs. How do you define Parent and Child
relationships in my situation or should I not go there.

Thank you in advance for your assistance.

>-----Original Message-----
>Lynn,
>
>Can a quote lead to multiple jobs? You say there may be
multiple quotes for
>a job, but can it lead the other way? If not, all you
need is to have an
>(optional) job number in the quote file.
>
>HTH
>
>--
>Rebecca Riordan, MVP
>
>Designing Relational Database Systems
>Microsoft SQL Server 2000 Programming Step by Step
>Microsoft ADO.NET Step by Step
>
>http://www.microsoft.com/mspress
>
>Blessed are they who can laugh at themselves,
>for they shall never cease to be amused...
>
>"Lynn" <anonymous@discussions.microsoft.com> wrote in
message
>news:285c401c46452$1b7d0310$a501280a@phx.gbl...
>> Thanks for your assistance Tina. I don't think I
>> explained myself enough. With what I have read about
>> many to many relationships, it stated that you had to
set
>> up a combined primary key with the primary keys from
the
>> two tables.
>>
>> My problem is that each job may not have a Quote and
each
>> Quote may not lead to a job. I initially was going to
>> set it up this way but it will not work for what we
>> need. I need to be able to track all Quotes and there
>> may be many different Quotes pertaining to one job or a
>> Job may not happern.
>>
>> I have Customers that may have Quotes and Jobs and I
may
>> have many quotes for one customer and the same with the
>> jobs. I have tried to think of a way to link the
quotes
>> and jobs but it does not work.
>>
>> Then to complicate the database even more I have Extra
>> Work information that needs to tie into the Jobs. This
>> should only be a one to many relationship.
>>
>> Thank you for your assistance and I hope this
information
>> better describes my problem.
>
>
>.
>

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)
  • Many to Many Relationships
    ... I am new to Access databases and to date I ... Quotes and Jobs both have sub ... understand correctly will link the Customers with Jobs ...
    (microsoft.public.access.tablesdbdesign)
  • Re: More assistance with Many to Many Relationships
    ... between Customers and Jobs, and a many-to-many between Quotes and Jobs, is ... (typically CustomerID) ... >>Designing Relational Database Systems ...
    (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)
Loading