访问03查询问题 [英] Access 03 query question

问题描述

我是非营利组织的律师和自学成才的程序员。

我正在尝试创建一个允许我搜索潜在的客户端数据库

基于社会保障＃或姓氏的利益冲突。

我创建了两个不同的表，每个表中包含以下字段：


ClientInfo

客户＃（主键）

名字

中间名

姓氏

SS＃

（其他联系方式）


OpposingInfo

____________（主键）

名字

中间名

姓氏

SS＃

（其他信息）


我有几个问题。

（1）OpposingInfo上的主键是否应该是客户＃并链接到

ClientInfo中的相同字段？或者更好的是拥有一个不同的主要
密钥，然后在

ClientInfo中创建一个与客户端＃相关的字段名称Client＃？我猜测后者


（2）是否可以创建一个允许我输入SS＃

的查询，它会搜索两个表匹配信息？如果在表格中找到了匹配，我希望结果显示客户名称和SS＃

和反对方名称和SS＃。


我一直在搜索新闻组的帖子，但我没有得到一个好的

答案。我确信它可以完成，只是在我的脑海中制作

连接时会出现连接，这将导致计算机连接。我是

使用Access 2003.


提前致谢。

Robert


---- ==通过Newsfeeds.Com发布 - 无限制 - 无限制 - 安全使用网新闻== ----
http://www.newsfeeds.com 世界排名第一的新闻组服务！ 120,000多个新闻组

---- =东海岸和西海岸服务器农场 - 通过加密实现全隐私= ----

I am an attorney in a non-profit organization and a self-taught programmer.
I''m trying to create a client db that will allow me to search for potential
conflicts of interest based either on Social Security # or on Last Name.
I''ve created two different tables with the following fields in each table:

ClientInfo
Client# (primary key)
First Name
Middle Name
Last Name
SS#
(other contact info)

OpposingInfo
____________ (primary key)
First Name
Middle Name
Last Name
SS#
(other info)

I have a couple questions.
(1) Should the Primary key on OpposingInfo be Client# and linked to the
same field in ClientInfo? Or would it be better to have a different primary
key and then create a field name Client# that is related to the Client# in
ClientInfo? I''m guessing the latter

(2) Is it possible to create a query that will allow me to enter a SS#
and it will search both tables for matching info? If a match is found in
either table, I would like the results to show the Client''s Names and SS#
and the Opposing Party''s Names and SS#.

I''ve been searching through news group postings and am not getting a good
answer to this. I am certain it can be done, just having trouble making the
connection in my mind that will make the connection in the computer. I''m
using Access 2003.

Thanks in advance.
Robert

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

推荐答案

" Robert" < sanfordlaw @ *** inebraska.com>在留言中写道

news：11 ************** @ sp6iad.superfeed.net ...

"Robert" <sanfordlaw@***inebraska.com> wrote in message
news:11**************@sp6iad.superfeed.net...

我是一名律师一个非盈利组织和一个自学成才的程序员。
我正在尝试创建一个客户端数据库，这将允许我根据社会安全＃或最后搜索潜在的利益冲突姓名。
我创建了两个不同的表，每个表中都包含以下字段：

ClientInfo
客户端＃（主键）
名字中间名
姓氏
SS＃
（其他联系方式）

OpposingInfo
____________（主键）
名字姓氏
SS＃
（其他信息）

我有几个问题。
（1）主键是否应该打开OpposingInfo是客户端＃并链接到ClientInfo中的相同字段？或者更好的是拥有一个不同的主键，然后创建一个与ClientInfo中的客户端＃相关的字段名称Client＃？我猜测后者

（2）是否可以创建一个允许我输入SS＃
的查询，它会在两个表中搜索匹配的信息？如果在表格中找到匹配项，我希望结果显示客户名称和SS＃
以及反对方名称和SS＃。
<我一直在搜索新闻组的帖子，但我没有得到一个好的答案。我确信它可以完成，只是在我的脑海中无法建立将在计算机中建立连接的连接。
我正在使用Access 2003。

I am an attorney in a non-profit organization and a self-taught programmer.
I''m trying to create a client db that will allow me to search for potential
conflicts of interest based either on Social Security # or on Last Name.
I''ve created two different tables with the following fields in each table:

ClientInfo
Client# (primary key)
First Name
Middle Name
Last Name
SS#
(other contact info)

OpposingInfo
____________ (primary key)
First Name
Middle Name
Last Name
SS#
(other info)

I have a couple questions.
(1) Should the Primary key on OpposingInfo be Client# and linked to
the same field in ClientInfo? Or would it be better to have a different
primary key and then create a field name Client# that is related to the
Client# in ClientInfo? I''m guessing the latter

(2) Is it possible to create a query that will allow me to enter a SS#
and it will search both tables for matching info? If a match is found in
either table, I would like the results to show the Client''s Names and SS#
and the Opposing Party''s Names and SS#.

I''ve been searching through news group postings and am not getting a good
answer to this. I am certain it can be done, just having trouble making
the connection in my mind that will make the connection in the computer.
I''m using Access 2003.

OpposingInfo表的目的是什么？它是否会与ClientInfo表中的
相关联？如果是，它与ClientInfo

表的关系是什么？一位客户有很多反对信息？一个客户只有一个

反对信息？


如果两个表或链接那里没有必要重复两个字段

表。回复更多关于你要做什么的信息和

我们会指导你走正确的道路。


Jeff

What is the purpose of the OpposingInfo table? Is it going to be linked to
the ClientInfo table? If yes, what is its relationship to the ClientInfo
table? One client has many opposing information? One client has only one
opposing information?

If the two tables or linked there is no need to repeat the fields in the two
tables. Reply back with more information about what you''re trying to do and
we''ll guide you on the correct path.

Jeff

OpposingInfo表的目的是存储有关

对方的信息，例如联系信息，社会安全号码，反对

律师和类似的事情。如果我在针对B的案件中代表A，

我需要确定我们办公室中没有人后来接受B'的案件。我的

如果我同时拥有一个

OpposingInfo表和一个ClientInfo表，它会更容易处理数据。


是的，这两个表需要相关。我需要能够搜索并确定
确定B对我过去或现在的任何客户的任何类型的连接。

B可能与许多客户有关，A可能与对很多对方来说

如果A有几件不同的诉讼正在进行（再次适合丈夫离婚，

诉讼房东等）。

希望这些额外的信息有用。


Robert

The purpose of the OpposingInfo table is to store information about an
opposing party, such as contact info, social security number, opposing
attorney and things like that. If I am representing A in a case against B,
I need to make certain that no one in our office later accepts B''s case. My
thought is it will be easier to work with the data if I have both an
OpposingInfo table and a ClientInfo table.

Yes, the two tables need to be related. I need to be able to search and
determine any type of connection B has to any of my past or current clients.
B could relate to many clients and A could relate to many opposing parties
if A has several different suits going on (suit again husband for divorce,
suit against landlord, etc.).

Hope this extra info helps.

Robert

OpposingInfo表的目的是什么？它是否会链接到ClientInfo表？如果是，它与ClientInfo
表的关系是什么？一位客户有很多反对信息？一个客户只有一个
对方信息？

如果两个表或链接那里没有必要重复两个表中的字段。回复更多关于你要做什么的信息，我们会指导你走正确的道路。

杰夫

What is the purpose of the OpposingInfo table? Is it going to be linked to
the ClientInfo table? If yes, what is its relationship to the ClientInfo
table? One client has many opposing information? One client has only one
opposing information?

If the two tables or linked there is no need to repeat the fields in the
two tables. Reply back with more information about what you''re trying to
do and we''ll guide you on the correct path.

Jeff

---- ==通过Newsfeeds.Com发布 - 无限制 - 无限制 - 安全的Usenet新闻== ----
http://www.newsfeeds.com 世界排名第一的新闻组服务！ 120,000多个新闻组

---- =东和西海岸服务器农场 - 通过加密的总隐私= ----

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

一般情况下，最好输入信息，比如


名字

中间名

姓氏

SS＃

其他联系信息


在一张桌子上。


然后你要么有一个''客户''复选框（布尔值）

将客户与对方分开，

或者你有一个指向客户表的链接

客户编号和其他客户信息。

如果您开始非常简单，您可以只有一张桌子

，其中包含所有信息。


当一个人可以链接到多个案件，或多个地址，或多个
银行账户或多个任何东西时，您需要更多的桌子。


但是即使你有多个链接表，你通常也需要

有一个Person tabl e for Persons。


这样可以轻松搜索人员或SSN

以查看是否存在冲突。


（大卫）


" Robert" < sanfordlaw @ *** inebraska.com>在留言中写道

news：11 ************** @ sp6iad.superfeed.net ...

In general, it is better to put information like

First Name
Middle Name
Last Name
SS#
Other Contact Info

all in one table.

Then you either have a ''client'' checkbox (boolean)
to separate out the clients from the counter-parties,
or you have a link to the Client table with the
client number and other client information.
If you start out very simply, you can have just one table
with all the information in it.

You need more tables when a person can be linked to
multiple cases, or multiple addresses, or multiple
bank accounts, or multiple anything.

But even if you have multiple link tables, you normally
have one Person table for Persons.

And that makes it easy to search for a Person or SSN
to see if there is a conflict.

(david)


"Robert" <sanfordlaw@***inebraska.com> wrote in message
news:11**************@sp6iad.superfeed.net...

我是一名律师一个非盈利组织和一个自学成才的程序员。
我正在尝试创建一个客户端数据库，这将允许我根据社会安全＃或最后搜索潜在的利益冲突姓名。
我创建了两个不同的表，每个表中都包含以下字段：

ClientInfo
客户端＃（主键）
名字中间名
姓氏
SS＃
（其他联系方式）

OpposingInfo
____________（主键）
名字姓氏
SS＃
（其他信息）

我有几个问题。
（1）主键是否应该打开OpposingInfo是客户端＃并链接到ClientInfo中的相同字段？或者更好的是拥有一个不同的主键，然后创建一个与ClientInfo中的客户端＃相关的字段名称Client＃？我猜测后者

（2）是否可以创建一个允许我输入SS＃
的查询，它会在两个表中搜索匹配的信息？如果在表格中找到匹配项，我希望结果显示客户名称和SS＃
以及反对方名称和SS＃。
<我一直在搜索新闻组的帖子，但我没有得到一个好的答案。我确信它可以完成，只是在我的脑海中无法建立将在计算机中建立连接的连接。
我正在使用Access 2003.

提前致谢。
罗伯特

---- ==通过Newsfeeds.Com发布 - 无限制 - 无限制安全的Usenet
新闻== ----
http://www.newsfeeds.com 世界排名第一的新闻组服务！ 120,000+
新闻组
---- =东海岸和西海岸服务器农场 - 通过加密实现全面隐私
= ----

I am an attorney in a non-profit organization and a self-taught programmer.
I''m trying to create a client db that will allow me to search for potential
conflicts of interest based either on Social Security # or on Last Name.
I''ve created two different tables with the following fields in each table:

ClientInfo
Client# (primary key)
First Name
Middle Name
Last Name
SS#
(other contact info)

OpposingInfo
____________ (primary key)
First Name
Middle Name
Last Name
SS#
(other info)

I have a couple questions.
(1) Should the Primary key on OpposingInfo be Client# and linked to
the same field in ClientInfo? Or would it be better to have a different
primary key and then create a field name Client# that is related to the
Client# in ClientInfo? I''m guessing the latter

(2) Is it possible to create a query that will allow me to enter a SS#
and it will search both tables for matching info? If a match is found in
either table, I would like the results to show the Client''s Names and SS#
and the Opposing Party''s Names and SS#.

I''ve been searching through news group postings and am not getting a good
answer to this. I am certain it can be done, just having trouble making
the connection in my mind that will make the connection in the computer.
I''m using Access 2003.

Thanks in advance.
Robert
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

这篇关于访问03查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！