Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    6

    Unanswered: Relationship between 3 tables.

    hi,

    I have a sales quotation, indent and orders table in db.

    In sales orders table i created a RefType(1=Quotation, 2=Indent) and RefNo (PK of Quotation/Indent).

    How i can create a relationship between these 3 tables ?

    Sales Quotation: New Order (New Sales Price).
    Sales Indent: New Order (Old Sales Price).

    Please advice me.

    Thank you,
    kiran.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Sounds like you may need to use an additional junction table for the relationships.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •