Results 1 to 2 of 2

Thread: Relationships

  1. #1
    Join Date
    Dec 2016
    Posts
    2

    Unanswered: Relationships

    Hi everyone,

    Im attempting a purchase order database but am getting stuck somewhere.

    I get the error

    'you can't add or change a record because a related record is required in table'.

    I have attached an image of the table relationships.

    Many thanks.Click image for larger version. 

Name:	Relationships.png 
Views:	5 
Size:	128.8 KB 
ID:	17232

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 34
    All these relationships are not required to make an order table.
    You only need parent/child tables.
    All the others; client,product,supplier,etc....don't need a relation,they are the feeder tables that supply what feeds the field.

    You DO need a relationship in
    TOrder and tOrderDetail.

    The master order number/date,and all the child items that make up the order.

Posting Permissions

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