I love reapeating fields, but you need to think at them as a tool for programming, not to store data.
So go on by creating tables and relationships.
hi couold you explain in more detail please
i have created a simple database that has a record for each postcode sector (4500 records) ach record will then log when we last delivered to them, the despatch code and the amount of households in each delivery.
this allows me to track when a sector was last delivered to and how many too. what would be best to do this?
I think ( my english isn't so good ) that you'll need 2 tables more in addition to the one ( Sectors ? ) that now you have ...
Deliveries Lines Items
A delivery can reach multiple sectors in a given date
a sector can be reached by more than a delivery
so you need to create a many to many relationship.
BTW: I do not understand what type of data you have to import.