Access 2003表和表单查询 [英] Ms Access 2003 Table and Form Query

问题描述

我只有2张桌子（1-客户联系人和2个账单明细）

我正在设计一个我需要在以下字段中计费的数据库


SrNo货物描述数量PerPcs



我想要每个发票都要重复上面的字段，但是Ms Ms有32个索引的限制要重复。



我希望在表单中显示的内容如下所示


SrNo商品描述数量PerPcs

1 ABCD 15 5件

2 XYZ 15 20件


这仅适用于一张发票和2件物品。但有时我有15个项目，我不能重复相同的序列号，描述，数量，费率和个人电脑。

Hi,


I have only 2 table (1- Client contact & 2- billing details)
I am designing a database for billing in which i need to have the below fields

SrNo Description of goods Qty Rate PerPcs


I wan the above fields for each and every invoice to be repeated but Ms Access has limitation of 32 indexes to be repeated.


What i want to display in the form is as below

SrNo Description of goods Qty Rate PerPcs
1 ABCD 15 5 pcs
2 XYZ 15 20 pcs

This is only for one invoice and 2 items. But sometimes i have 15 items and in which i can''t repeat the same Serial no, description, qty, rate and pcs.

推荐答案

欢迎光临字节！


我很困惑。你想要什么帮助？

Welcome to Bytes!

I''m confused. What exactly do you want help with?

我有2个表格和2个表格如下

第一个客户联系

第二个账单明细


客户联系方式包含以下字段

客户ID，公司名称，地址，电话，手机，电子邮件，网站



账单明细包含以下字段

发票ID，发票日期，客户ID，公司名称，地址，Sr.NO。，商品描述，数量和费率。


我想首先链接账单详细信息 - 客户端ID与客户端联系人 - 客户端ID，以便它显示CLient中的ID列表康泰克。


然后，一旦我点击特定的身份证，它就会自动显示与该特定身份证相关的公司名称和地址。


如果您需要更多信息，请告诉我

I have 2 forms and 2 tables as below
1st Client Contact
2nd Bill Details


Client Contact contains the below fields
Client Id, Company Name, Address, Ph, Mob, Email, Website


Bill Details Contains below fields
Invoice Id, Invoice Date, Client Id, Company Name, Address, Sr.NO., Description of goods, qty and rate.


I want to first link the Bill details - Client Id with Client Contact-Client Id so that it displays me the list of id''s that are in CLient Contac.

Then once i click on the a specific id it should automatically display the Company Name and Address related to that particular id.

Please let me know if you need more information

听起来您首先需要一个将两个表链接在一起的查询。这将包括您需要显示的所有详细信息。你有没有完成这部分的工作？


当你有这个部分时，你可以考虑如何显示名称& 地址信息。我不确定这一般需要什么特别的东西。如果你愿意的话，你可以把它放在表格的主要部分上。


无论如何，让我知道你在哪里，我可以看看提供特定的帮助。

This sounds like you first need a query that links the two tables together. This would include all the details you require to be displayed. Have you got this part done already?

When you have that you can think about how to show the Name & Address info. I''m not sure this requires anything special generally. You can probably fit it on the main part of the form for all records if you wanted to.

Anyway, let me know where you''re up to and I can look at providing the specific help that''s required.

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