Ordrerlinier - hvordan?

Prøv lige at præcisere det nærmere...
Er det noget med én til mange relation ?
Eller er det recordsetID du vil have omdøbt/relateret til \"ordrelinierne\"

mvh martens

Ja, det lyder rigtigt.

Giv et eksempel .... på et ordrenummer

zack
If your tables are OK (normalized) and all that, then create a form with the order table as its record source. Then create a form with the order lines as its record source. Then drag the order lines form onto the order form. This creates a sub form. Then you have to alter the properties for your sub form. Double click on the sub form object to open your properties and alter the Link child fields and link master fields. It would be logical that the forms are linked on the order number, but as martens syas, it could be recordID.

When you create a new order the order number gets updated in the order line records that are also created.

When you create a new order

The order form should preferably have the fields in the form header and the sub form in the detail

Ignore last line \"When you create a new order\".