M
MikeJohnB
I know I should not have done it this way BUT!
Tables
TbL_Main_Data (Top level Table_
Tbl_Quotation (Second Level Table linked to top level as below)
These through Queries form the source for two forms, (Frm_Main_Data) and a
sub form Called (Frm_Line_Item)
the two fields that link these two forms are
Tbl_Main_Data (Quote_Ref)(Unique)
Tbl_Line_Item (Quotation_Ref)(Many)
These are linked with Enforce referentian integrity, with cascade udate and
delete all ticked. giving a one to many link.
Here is the problem
On the Tbl_Line_Item I have a field called (Line_item_No)
After deleting a line item, I want to be able to re-number the sequence of
line items sequentially as indicated below
line Items 3 and 7 deleted leaving
1, 2, 4, 5, 6. 8, 9, 10 etc if there are more line items.
to be re-numbered
1, 2, 3, 4, 5, 6, 7, 8,
I know how this should be done using the recordset in vba but I am lost on
the syntax.
Can anyone assist?
Tables
TbL_Main_Data (Top level Table_
Tbl_Quotation (Second Level Table linked to top level as below)
These through Queries form the source for two forms, (Frm_Main_Data) and a
sub form Called (Frm_Line_Item)
the two fields that link these two forms are
Tbl_Main_Data (Quote_Ref)(Unique)
Tbl_Line_Item (Quotation_Ref)(Many)
These are linked with Enforce referentian integrity, with cascade udate and
delete all ticked. giving a one to many link.
Here is the problem
On the Tbl_Line_Item I have a field called (Line_item_No)
After deleting a line item, I want to be able to re-number the sequence of
line items sequentially as indicated below
line Items 3 and 7 deleted leaving
1, 2, 4, 5, 6. 8, 9, 10 etc if there are more line items.
to be re-numbered
1, 2, 3, 4, 5, 6, 7, 8,
I know how this should be done using the recordset in vba but I am lost on
the syntax.
Can anyone assist?