Increment a number but also make it editable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top