联系表 [英] Contact Table

问题描述

我想定义一个名为Contacts的表。我有两种类型的联系方式，营业时间联系和下班后联系。

我需要提出以下有效建议。或者如果有不同的方式让我知道

1.

ContactID，BHContact，BH Mobile，BHPhone，BHEmail，AHContact，AHMobile，AHPhone，AHEmail。


2.

联系ID，联系人，手机，电话，电子邮件，类型


谢谢

解决方案

我想定义一个名为Contacts的表。我有两种类型的联系方式，营业时间联系和下班后联系。

我需要提出以下有效建议。或者如果有不同的方式让我知道

1.

ContactID，BHContact，BH Mobile，BHPhone，BHEmail，AHContact，AHMobile，AHPhone，AHEmail。


2.

联系ID，联系人，手机，电话，电子邮件，类型


谢谢

欢迎任何消化

欢迎任何消息

小心你想要的...... :)


但是说真的，我想更常见的方法是建立一个联系表一个Type字段，然后在表单上（或在查询中）将那些与同一个人相关的字段拉到一起。


现在我想起来了，不是吗分布式文件中的联系表样本？或新表向导，或帮助文本？我忘了它的位置。

小心你想要的...... :)


但是严肃地说，我想更常见的方法是将一个带有Type字段的联系人表格放在一起，然后在表格上（或在查询中）将那些与同一个人相关的表格拉到一起。


现在我想一想，分布式文件中是否有联系表样本？或新表向导，或帮助文本？我忘了它在哪里。

我会检查向导，

与我有联系，一个人可以是BHcontact，或者是AHcontact，还有我的如果联系人不一定是一个人，它可以是一个站点（位置）。

I want to define a table called Contacts. I have two types of contacts, business hour contact and after hours contact.
I need suggestion on the following that which is efficient. Or if there are different ways let me know
1.
ContactID, BHContact, BH Mobile, BHPhone, BHEmail, AHContact, AHMobile, AHPhone, AHEmail.

2.
ContactID, Contact, Mobile, Phone, EMail, Type


Thanks

解决方案

I want to define a table called Contacts. I have two types of contacts, business hour contact and after hours contact.
I need suggestion on the following that which is efficient. Or if there are different ways let me know
1.
ContactID, BHContact, BH Mobile, BHPhone, BHEmail, AHContact, AHMobile, AHPhone, AHEmail.

2.
ContactID, Contact, Mobile, Phone, EMail, Type


Thanks

Any sugestion is welcomed

Any sugestion is welcomed

Be careful what you wish for... :)

But seriously, I imagine the more usual approach would be to have a table of contacts with a Type field, and then pull together on a form (or in a query) the ones which relate to the same person.

Now that I think about it, aren''t there samples of contact tables in the distributed files? Or the new table wizard, or the help text? I forget where it was.

Be careful what you wish for... :)

But seriously, I imagine the more usual approach would be to have a table of contacts with a Type field, and then pull together on a form (or in a query) the ones which relate to the same person.

Now that I think about it, aren''t there samples of contact tables in the distributed files? Or the new table wizard, or the help text? I forget where it was.

I will check the wizard,
with the contact that I have, one person can be BHcontact, or AHcontact, and also in my case the contact doesn''t have to be a person it can be a site(location).

这篇关于联系表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！