Hi everyone,
I am a beginner in MS Access and trying to create a database for my sales. What I am trying to do but can't is this:
I want to create a table to record my sales, the first field would be the order number; withing each order, there would be one item or more. So in order to overcome the duplicate issue, I thought of adding an item number in another field, then another field to combine both numbers and that would be the order id and primary key.
Example:
Field 1 (order#) : Record1=1840; Record2=1840; Record3=1840
Field 2 (Item#): Record1= 01; Record2=02; Record3=03
Field 3 (Order ID): Record1=1840-01; Record2=1840-02; Record3=1840-03
Is there anyway I can achieve this?
Thank you, in advance
I am a beginner in MS Access and trying to create a database for my sales. What I am trying to do but can't is this:
I want to create a table to record my sales, the first field would be the order number; withing each order, there would be one item or more. So in order to overcome the duplicate issue, I thought of adding an item number in another field, then another field to combine both numbers and that would be the order id and primary key.
Example:
Field 1 (order#) : Record1=1840; Record2=1840; Record3=1840
Field 2 (Item#): Record1= 01; Record2=02; Record3=03
Field 3 (Order ID): Record1=1840-01; Record2=1840-02; Record3=1840-03
Is there anyway I can achieve this?
Thank you, in advance