AnsweredAssumed Answered

Unique number from four relationships

Question asked by heidisagat on Feb 11, 2014

Title

Unique number from four relationships

Post

     I have two databases who are related. Invoice and orders.

     In Invoice i use relationship 1 for order number 1 which lookup 4 fields: number, text, format and amount.

     For order number 1 can there be up to 5 lines with text for text, format and amount.

     relationship 2 for order number 2 lookup the same fields. For order number 2 is there only 1 line for text, format and amount.

     relationship 3 for order number 3 lookup the same fields. For order number 3 is there only 1 line for text, format and amount.

     relationship 4 for order number 4 lookup the same fields. For order number 4 is there only 1 line for text, format and amount.

     i need to validate that order number is unique, regardless if the number is set in order number 1, 2, 3 or 4.

     I have made a related database (invoice orders)  where a second field (OrderID) set to auto enter calculation "order number".

     I have a portal in invoice with the fields "order number", "text", "format" and "amount".

     When a new order number is set, a new order is made in my "invoice orders".

     The problem is that i sometimes need to get more lines for order number 1.

     See images what i mean.

Skjermbilde_2014-02-11_kl._14.24.57.png

Outcomes