Click here to Skip to main content
16,017,015 members
Home / Discussions / Database
   

Database

 
PraiseRe: structure question 2 Pin
Joan M19-Jul-19 1:31
professionalJoan M19-Jul-19 1:31 
QuestionBest practices for database tables. Pin
RLD7114-Jul-19 12:37
professionalRLD7114-Jul-19 12:37 
AnswerRe: Best practices for database tables. Pin
CHill6017-Jul-19 23:17
mveCHill6017-Jul-19 23:17 
AnswerRe: Best practices for database tables. Pin
Mycroft Holmes18-Jul-19 11:57
professionalMycroft Holmes18-Jul-19 11:57 
GeneralRe: Best practices for database tables. Pin
RLD7121-Jul-19 3:37
professionalRLD7121-Jul-19 3:37 
Questionstructure question Pin
Joan M11-Jul-19 1:30
professionalJoan M11-Jul-19 1:30 
AnswerRe: structure question Pin
Eddy Vluggen11-Jul-19 2:01
professionalEddy Vluggen11-Jul-19 2:01 
GeneralRe: structure question Pin
CHill6018-Jul-19 1:30
mveCHill6018-Jul-19 1:30 
Quote:
and a PK on the customers name. It's a nice way to ensure that there's a single unique identifyable customer for each project.
It's nice until you end up with two customers with the same name! Laugh | :laugh:

In my case I also can't use part of the address as I have a Father/Son scenario with the same name living at the same address (besides, people do move house occasionally).

So we have autonumbers - the onboarding process does the necessary checks for duplication
GeneralRe: structure question Pin
Eddy Vluggen18-Jul-19 22:53
professionalEddy Vluggen18-Jul-19 22:53 
QuestionQuery numbering in groups in access database ? Pin
Member 24584674-Jul-19 23:50
Member 24584674-Jul-19 23:50 
SuggestionRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 7:51
mveCHill6010-Jul-19 7:51 
GeneralRe: Query numbering in groups in access database ? Pin
Member 245846710-Jul-19 17:57
Member 245846710-Jul-19 17:57 
GeneralRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 21:38
mveCHill6010-Jul-19 21:38 
QuestionHow To Fix SQL Database Error 824 ? Pin
Member 24584673-Jul-19 22:10
Member 24584673-Jul-19 22:10 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan3-Jul-19 23:44
mveRichard MacCutchan3-Jul-19 23:44 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen4-Jul-19 2:49
professionalEddy Vluggen4-Jul-19 2:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584674-Jul-19 17:40
Member 24584674-Jul-19 17:40 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov4-Jul-19 20:20
Victor Nijegorodov4-Jul-19 20:20 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584674-Jul-19 23:49
Member 24584674-Jul-19 23:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov4-Jul-19 23:52
Victor Nijegorodov4-Jul-19 23:52 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan5-Jul-19 1:47
mveRichard MacCutchan5-Jul-19 1:47 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen5-Jul-19 1:04
professionalEddy Vluggen5-Jul-19 1:04 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 245846718-Jul-19 18:21
Member 245846718-Jul-19 18:21 
QuestionRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen18-Jul-19 22:54
professionalEddy Vluggen18-Jul-19 22:54 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Shraddha_Patel22-Aug-19 23:52
Shraddha_Patel22-Aug-19 23:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.