Increment a number but also make it editable?

[Guest]

Hi, I am creating a delivery notes system for out ordering database.

I have a table called Order_Details where I have a field called
Order_Items_ID I need this field to increment by one for every new record,
but I also need to be able to change this number as I need each item within
an order to have this field as the same number. I.e. if 3 items in an order
are all printed on the same delivery note I need to change the Order_Items_ID
number for each item to be the same number so that they all print on the same
report?

 

[Rebecca Riordan]

Seems to me that you're thinking about this incorrectly. From your
description, it's not an item id, it's a delivery note id. Wouldn't it be
easier to calculate and assign it when you create the delivery note?

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress