database
implementation in access
creating the 'Order' entity
I then created the Order entity in design view, below is a screen dump of this:
I also needed to make the Order Number the primary key, I did this the same way I did for the other entity - highlighting the field and press the key icon button in the table design menu. Below is a screenshot of the end result:
Click next to continue...