缩写的一致性 [英] consistency in abbreviations
问题描述
如果一个用户输入Laurel Drive，另一个人进入Laurel Dr.还有
另一个忘记了这段时间并进入Laurel Dr - 有没有办法使b
强制执行一致性，以便103 Laurel Drive当不同的用户输入时，不会出现三个不同的地址吗？
TIA
If one user enters "Laurel Drive" and another enters "Laurel Dr." and still
another forgets the period and enters "Laurel Dr" - is there a way to
enforce consistency so that "103 Laurel Drive" doesn''t appear as three
different addresses when entered by the different users?
TIA
推荐答案
" Catherine Jo Morgan" < CJ ****** @ hemc.net>写在
新闻：R8 ******************** @ hemc.net：
"Catherine Jo Morgan" <cj******@hemc.net> wrote in
news:R8********************@hemc.net:
如果一个用户输入Laurel Drive，另一个人进入Laurel
Dr.还有一个人忘记了这个时期并进入了Laurel
Dr. - 有没有办法强制执行一致性，以便103月桂冠车道
由不同用户输入时不会显示为三个不同的地址？
TIA
正确的数据库设计！用户不需要重新输入
重复数据。如果您从
a客户输入每个订单的地址，您需要重新设计，以便客户有一张桌子，
包含客户的ID，名称，地址，电话等。
当新订单进入时，您只需链接到客户的ID
号码，而不是必须重新输入所有内容。
Bob Q.
If one user enters "Laurel Drive" and another enters "Laurel
Dr." and still another forgets the period and enters "Laurel
Dr" - is there a way to enforce consistency so that "103
Laurel Drive" doesn''t appear as three different addresses when
entered by the different users?
TIA
Proper database design! Users should not need to be re-entering
repeating data. If you are entering the address for each order from
a customer, you need to redesign such that customers have a table,
which contains the customer''s ID, name, address, phone, etc.
When a new order comes in, you simply link to the customer''s ID
number, and don''t have to retype everything.
Bob Q.
" Catherine Jo Morgan" < CJ ****** @ hemc.net>在消息中写道
新闻：R8 ******************** @ hemc.net ...
"Catherine Jo Morgan" <cj******@hemc.net> wrote in message
news:R8********************@hemc.net...
如果一个用户输入Laurel Drive另一个人进入Laurel Dr.并且仍然会忘记这段时间并进入Laurel Dr - 有没有办法强制执行一致性，以便103 Laurel Drive当不同的用户输入时，不会出现三个不同的地址？
If one user enters "Laurel Drive" and another enters "Laurel Dr." and still
another forgets the period and enters "Laurel Dr" - is there a way to
enforce consistency so that "103 Laurel Drive" doesn''t appear as three
different addresses when entered by the different users?
No.
在这种情况下，您可以做的最好的事情是创建简单但灵活的过滤/搜索功能，并允许用户确定每个新的
记录插入是否该实体已经在
之前的数据库中输入它。这个问题与数据处理一样久了。
-
我没有查看电子邮件帐户附上
到此消息。发送给... ...
在Hunter dot com的RBrandt
No.
In such situations the best you can do is create simple, but flexible
filtering/search functionality and allow the user to determine with each new
record insertion whether that entity is already in the database prior to
entering it. This problem is as old as data processing.
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
" Bob Quintal" < BQ ****** @ generation.net>在消息中写道
news：13 ****************************** @ news.teranew s。 com ...
"Bob Quintal" <bq******@generation.net> wrote in message
news:13******************************@news.teranew s.com...
" Catherine Jo Morgan" < CJ ****** @ hemc.net>在
新闻中写道：R8 ******************** @ hemc.net：
"Catherine Jo Morgan" <cj******@hemc.net> wrote in
news:R8********************@hemc.net:
如果一个用户进入劳雷尔驱动器另一个人进入Laurel
Dr.还有一个人忘记了这个时期并进入了Laurel
Dr. - 有没有办法强制执行一致性，以便103月桂冠车道
由不同用户输入时不会显示为三个不同的地址？
TIA
If one user enters "Laurel Drive" and another enters "Laurel
Dr." and still another forgets the period and enters "Laurel
Dr" - is there a way to enforce consistency so that "103
Laurel Drive" doesn''t appear as three different addresses when
entered by the different users?
TIA
正确的数据库设计！用户不需要重新输入重复数据。如果您从客户输入每个订单的地址，您需要重新设计，以便客户有一张表格，其中包含客户的ID，姓名，地址，电话等。 br />
当新订单进入时，您只需链接到客户的ID号码，而不必重新输入所有内容。
Proper database design! Users should not need to be re-entering
repeating data. If you are entering the address for each order from
a customer, you need to redesign such that customers have a table,
which contains the customer''s ID, name, address, phone, etc.
When a new order comes in, you simply link to the customer''s ID
number, and don''t have to retype everything.
但是OP并没有表明这是一个Orders数据库。也许他们将数据输入到Customers表本身，或者Prospects表中，或者
调查等等。
-
我没有查看此邮件附带的电子邮件帐户
。发送给...
在Hunter dot com的RBrandt
But the OP didn''t indicate that this is an Orders database. Perhaps they are
entering data into the Customers table itself, or a Prospects table, or a
Survey, etc..
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
这篇关于缩写的一致性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
