Martin.Flynn wrote:I can manage without it but looks like I'll need to learn base!
Thanks for your help
Yes, shure. As soon as you need some concept of uniqueness, you are lost with a spreadsheet. There is not much to learn about Base. The steepest learning curve is the overall concept of relational databases, relations, normalization and Structured Query Language (SQL). Many small companies earn their living with this kind of stuff. All software tools for running the IT of a company are based on databases and they are expensive.
Since you don't know about spreadsheets nor databases, you are far better off learning about databases first. Then you may decide in favour of any other database but Base or Base as just another tool to access your database. Spreadsheets *seem* to be easier but they become extremely comlpex when you try to build something reliable that looks like a database.
btw: =ROW() without arguments gives the unique number of this row. But you must not sort the list nor insert rows then.