Design query

[brunodg0]

Hi,

I designed a db for orders. An order exists of one or more positions (lines) and each position can be delivered separately. Now, I want to make an invoice containing all orders and positions that have been delivered.
Eg: order #521 has 3 positions (1, 2 and 3). Positions 1 and 2 have been delivered, 3 not yet. My invoice of order #521 should contain position 1 and 2. When position 3 is delivered, another invoice will be created. Remark: the invoice number depends on the delivery note (inserted manually).
Any ideas?

Thanks!

 

[JeanW]

Make a relationship between Orders and position, key OrderID & Delevery at one side and f.i. OrderID & Pos at the other side...
With a GotoRelatedRecords scriptstep and show only related you can select and print....

Although, it seems to me that you didn't make a logical data model before your physical model....

HTH