spikepl
Eledittingent Beliped
- Local time
- Tomorrow, 00:08
- Joined
- Nov 3, 2010
- Messages
- 6,142
Your naming is, unfortunately, a mess. Sort that out first.
Here is a naming convention you can choose to use: http://www.access-programmers.co.uk/forums/showthread.php?t=225837
Here is a list of words you should not use to name objects in your db: http://allenbrowne.com/AppIssueBadWord.html
Finally, do not use the same word for naming a table and naming a field in the table - that is absolutely confusing, and it will confuse you too in 14 days when you will have to make changes but forgot what was what.
Here is a naming convention you can choose to use: http://www.access-programmers.co.uk/forums/showthread.php?t=225837
Here is a list of words you should not use to name objects in your db: http://allenbrowne.com/AppIssueBadWord.html
Finally, do not use the same word for naming a table and naming a field in the table - that is absolutely confusing, and it will confuse you too in 14 days when you will have to make changes but forgot what was what.