如何在Microsoft Access的tblOrderLines表中设置行编号？

Hey there, I know you’ve been stuck on this Access database problem for weeks—totally get how frustrating it is when you can’t tell if your approach is off or you’re missing a critical detail. Let’s clearly outline your existing table setup first:

tblOrderDetails #

This table tracks core order information with the following fields:

• ORDERID: Unique identifier for each order
• DEALER: Name of the dealer associated with the order
• CREATEDATE: Date the order was created

Sample Data:

4051、Willow、4/17/18；4052、Oak、4/17/18

tblOrderLines #

This table captures line-item details for each order, linked via ORDERID:

• ROWID: Unique identifier for each order line
• ORDERID: Links back to the corresponding order in tblOrderDetails
• PRODUCTSKU: SKU (stock keeping unit) for the ordered product
• ORDERLINENUMBER: Sequence number for the line item within the order

Sample Data:

1、4051、Desk……

内容的提问来源于stack exchange，提问作者Adam Baney