多个表单链接到一个数据表 [英] Multiple forms linked to one data Table

问题描述

大家好！我是新手，所以请不要大话。 :-)这是我第一次建立数据库，但我觉得我正在学习并取得进步。这是我的问题：


我正在构建的数据库严格用于数据的撤销，而不是更新（暂时）。我有一个数据表，其中包含14个不同客户（企业）的信息，我也只为报告创建了一个查询。我创建了一个交换机，它有一个按钮，链接到我为每个客户创建的14种不同形式。我这样做的原因是因为我希望按下按钮时出现客户的徽标，所以我认为这是最简单的方法（我能够为每个表单设置每个客户徽标的图片） 。每个表单基本上彼此相同以便检索相同类型的信息。我可以设置我的第一个客户来获取我想要的报告，使用此表达式（[Forms]！[AIR PACIFIC]！[cboAirline]）在查询的customer字段中的条件点。我还在同一查询的请求日期条件字段中使用此表达式（在[Form]！[AIR PACIFIC]！[txtStartDate]和[Form]！[AIR PACIFIC]！[txtEndDate]）之间。但是，当我去设置我的第二个客户时，我无法做到。在我进一步浪费时间之前，是否有可能做我想做的事情？任何人提供的任何帮助将不胜感激。在此先感谢!!

Hello everyone!! I''m a newbie here so please no big words. :-) This is my first time building a database, but I feel like I am learning and making progress. Here is my problem:

The database I''m building is strictly for retrevial of data, not updating (for now). I have one data table that contains information on 14 different customers (businesses), and I also only created one query for a report. I created a switchboard that has a button linked to 14 different forms I created for each customer. The reason I did that was because I wanted the customer''s logo to appear when their button is pressed, so I thought that was the easiest way (I was able to setup each form with a picture of each customer''s logo). Each form is basically set up identical to each other as to retreive the same types of information. I am able to set up my 1st customer to get the report I want, using this expression ( [Forms]![AIR PACIFIC]![cboAirline] )in the criteria spot in the customer field of the query. I also use this expression ( Between[Form]![AIR PACIFIC]![txtStartDate] And [Form]![AIR PACIFIC]![txtEndDate] ) in the Request Date criteria field of the same query. However, when I go to setup my 2nd customer, I''m not able to. Before I waste my time even further, is it even possible to do what I am trying to do? Any help anyone provides will be greatly appreciated. Thanks in advance!!

推荐答案

您应该只使用一个表格，表格中存储的徽标位置和表格上的图像链接到该位置。

You should only use one form with the location of the logo stored in the table and the image on the form linked to that location.

你真的不能确切地说出你想要做什么，只是你所尝试的。但是，这里有一些提示：

1）阅读数据库规范化和表结构。这是设计数据库的每个人都应该知道并遵循的事情。

2）在存储客户信息的表格中，包括徽标字段。这样，您就有一个适用于所有客户的表单。否则，你将不得不做很多工作来添加另一个客户。

You don''t really say exactly what you are trying to do, only what you have tried. However, here are a few tips:
1) Read Database Normalization and Table Structures. This is something everyone who designs databases should know and follow.
2) In the table that stores your customer information, include a field for the logo. That way, you have one form that works for all of your customers. Otherwise, you will have to do a lot of work to add another customer.

Seth ......


感谢您的回复和信息。我正在尝试创建一个数据库，我办公室的人员可以使用该数据库为特定客户提取数据。我正在尝试将所有14个表单链接到一个数据表和一个查询。我试图使用BETWEEN查询中的函数（在[Form]！[AIR PACIFIC]！[txtStartDate]和[Form]！[SUN COUNTRY]！[txtEndDate]）之间，所以无论使用哪种形式，它都会为该客户提取信息只是，但我想BETWEEN功能不起作用。

Seth...

Thanks for the reply and the info. I am trying to create a database that the people in my office can use to pull data for a specific customer. I''m trying to link all 14 forms to the one data table and one query. I was trying to use a "BETWEEN" function in the query (Between[Form]![AIR PACIFIC]![txtStartDate] And [Form]![SUN COUNTRY]![txtEndDate]), so regardless of which form is being used, it will pull the information for that customer only, but I guess the "BETWEEN" function doesn''t work.

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