flecsynotpepsi
New member
- Local time
- Today, 04:41
- Joined
- Feb 14, 2018
- Messages
- 2
Hello All,
I have a probably basic design question, but I do need some help. I began designing this database and entering data into it. As one can see from the attached relationship table, I was unaware that it was advised to have a ID field with autonumber set as the primary key in each table. I was told his was because lookups can take longer with larger databases. If a database has something like 1000+ items, should I change the tables or continue as is?
I am afraid of changes I make would alter data I have already entered and corrupt forms I have already setup.
Thanks.
I have a probably basic design question, but I do need some help. I began designing this database and entering data into it. As one can see from the attached relationship table, I was unaware that it was advised to have a ID field with autonumber set as the primary key in each table. I was told his was because lookups can take longer with larger databases. If a database has something like 1000+ items, should I change the tables or continue as is?
I am afraid of changes I make would alter data I have already entered and corrupt forms I have already setup.
Thanks.