Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2011

    Unanswered: Table Relationship


    In purchase module having Quotation,Indent and Order tables.

    Quotation is used for new purchase orders.
    Indent is for repeated order which means if there is not change in the unit price of the item use the last purchase price.

    when i am created a purchase order i am using a reference no column in the purchase order table to store the quotation/indent no.

    Now how i can create a relation ship between these 3 tables by Enforce Referential Integrity.

    Please help me...

    Thank You,
    Attached Thumbnails Attached Thumbnails Relationship.JPG  

Posting Permissions

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