R
Robin
Hi All,
Access amateur here so go easy! I have a database that we use for sales
order management. The orders are entered using two linked forms (main and
sub data sheet) and the data is stored into two tables, which are linked via
the orderID primary key in the main table and they have a one-to-many
relationship. The main table stores the order header info (customer, account
number, order date) and the subdatasheet table stores the products, prices
and quantities on the order. I would like to add an autonumber to the sub
datasheet that starts at 1 for every order and increases by 1 for each order
line entered! Example:
OrderNo LineNo
12345 1
12345 2
67890 1
67890 2
Hope this makes sense,
Thx
Robin
Access amateur here so go easy! I have a database that we use for sales
order management. The orders are entered using two linked forms (main and
sub data sheet) and the data is stored into two tables, which are linked via
the orderID primary key in the main table and they have a one-to-many
relationship. The main table stores the order header info (customer, account
number, order date) and the subdatasheet table stores the products, prices
and quantities on the order. I would like to add an autonumber to the sub
datasheet that starts at 1 for every order and increases by 1 for each order
line entered! Example:
OrderNo LineNo
12345 1
12345 2
67890 1
67890 2
Hope this makes sense,
Thx
Robin