As @Geoff_Bernstein mentioned, each primary field should be unique, otherwise things can get messy pretty quickly. The main reason it needs to be unique is because of relationships to other tables, you need to be able to identify each record uniquel...
The response from @kuovonne describes your solution in a nutshell, and would be the ideal way to build it. As mentioned, if you are used to only a spreadsheet point of view, databases can be a bit confusing at first glance. There is a lot of info on ...
Hi There,
You can Use the first column to create the auto numbers by customizing field type and select “Auto number”, use another field to then enter Cat names.
Add a column for birthdate and select Date as the format type
Asuming your date column is...