Form divided into various sheets

[vanny]

Hi all,

I need some suggestions regarding setting up a form that needs to store Order Bookings by Area. That is for example if I have 12 Areas shall i create 12 Tables as the Order Number has to be related accordingly such as
A12-07-000 related to Area 12 and the Order No has to be unique according the Area chosen.

Any ideas of how i can go about this?

Thanks.