使用模板为客户创建自动发票 [英] Using templates to create automated invoices for customers
问题描述
我有一个处理订单的数据库;我的表单上有一个选项，允许用户自动生成发票，我如何创建一个模板（以报表的形式），可以自动包含客户详细信息（即他们的地址）？！我相对较新的Access所以任何帮助将非常感激。非常感谢！
Hi,
I have a database which will process orders; i have an option on my form that should allow users to automatically generate an invoice, how would I go about creating a template (in the form of a report) that can automatically include the customers details (i.e. their address)?! im relatively new to Access so any help would be hugely appreciated. Thanks a lot!
推荐答案
根据您的要求，您只需要为您的报告创建一个查询。查询应包括Orders表中的字段和Customers表中所需的客户数据字段。
为了进一步提供建议，我们需要知道您拥有哪些表，结构和关系。
By the sound of what you are asking, you just need to create a Query for your report to be based on. The Query should include fields from your Orders table and the required customer data fields from your Customers table.
In order to advise further, we would need to know what tables you have, structure and relationships.
根据您的要求，您只需要为您的报告创建一个查询。查询应包括Orders表中的字段和Customers表中所需的客户数据字段。
为了进一步提供建议，我们需要知道您拥有哪些表，结构和关系。
By the sound of what you are asking, you just need to create a Query for your report to be based on. The Query should include fields from your Orders table and the required customer data fields from your Customers table.
In order to advise further, we would need to know what tables you have, structure and relationships.
我有一张顾客表，内容如下：
客户ID
title
forename
姓氏
（地址详情）
电子邮件地址
这是链接的（ tdlOrders;一对多） with：
orderID
date
OrderLineID
CustomerID
总计< - - 我应该存储一个计算区域
tblOrderLine
OrderLineID
数量
产品ID
子总额
产品有ProductID和ProductType，价格和其他各种细节......
I have a customers table with the following:
Customer ID
title
forename
surname
(address details)
email address
this is linked (one to many) to tblOrders; with:
orderID
date
OrderLineID
CustomerID
Total <--- SHOULD I STORE A CALCULATED FIELD
tblOrderLine
OrderLineID
Quantity
ProductID
Sub Total
the products has ProductID and ProductType, Price and various other details...
我已经为你准备了最初的MetaData表。仍有许多空白需要填补，以帮助我们帮助您。 BTW你的（地址详情）很好，因为它没有用于任何地方链接或查找记录。 （大多数）其他字段需要完整的信息，但我们才能正确地建议答案。
I''ve put together for you an initial stab at the table MetaData. There are still many gaps to be filled in to help us to help you. BTW Your (address details) is fine as it''s not used anywhere to link or find records. (Most of) the other fields need the full information though before we can correctly suggest answers.
这篇关于使用模板为客户创建自动发票的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
