返回表单的搜索表单 [英] search form which returns forms
问题描述
大家好，我是新手，我需要你的帮助。
我有一个包含20个桌子的数据库，每张桌子都创建了一个表格。
在每个表中我有2个相同的字段，lnumber和st.date。
我想要创建的搜索表单必须包含这两个字段用于搜索和当我完成那些我想要返回那些参数的表格。
可以有2个a111 lnumbers但它们有不同的st.date。
例如，我打开一个搜索表单，我在第一个框a111输入，在第二个框中我想要一个带有a111的st.dates的下拉菜单。
然后我选择一个约会。
在我按下搜索后，我想用lnumber a111向我展示所有20个表格，并向我展示我选择的表格。
然后我按下表格i想要和观看，并有选择回去选择一个不同的。
抱歉我的英语，任何规格问我。
谢谢
hello everyone, i am new in access and i need your help.
I have a db with 20 tables and for each table i have create a form.
In every table i have 2 same fields , lnumber and st.date.
The search form i want to create must have these 2 fields for search and when i complete those i want to return me the forms with those parametres.
There can be 2 a111 lnumbers but they have different st.date.
For example , i open a search form , i type in the first box a111 and in the second one i want a drop down menu with the st.dates that a111 has.
Then i choose a date .
After i press search and i want to show me all 20 forms with lnumber a111 and st.date the one i choose .
Then i press the form i want and watch and have the option to go back and choose a different one.
sorry for my english , for any specification ask me.
Thank you
推荐答案
所有20个表之间有什么区别？他们听起来非常规范化。如果我是对的，那么你可以从规范化你的桌子中受益匪浅。有关详细信息，请参阅数据库规范化。
否则，您必须使用UNION查询将所有表连接在一起。这不是一个好主意。
What is the difference between all 20 tables? They sound very denormalized. If I''m right, then you would greatly benefit from normalizing your tables. See Database Normalization for more information on that.
Otherwise, you would have to join all the tables together using a UNION query. This would not be a good idea.
表格代表文档，我像原始文档一样形成它们。
每个文档都有lnumber，st.date和其他varius信息。
i不知道这是否有帮助，因为我无法理解你关于我的数据库的链接，但它非常有帮助因为我刚开始使用访问ty
the tables represent documents and i formed them like the original documents.
every document has lnumber , st.date , and other varius informetions.
i dont know if that helped because i couldnt understand very well your link about my db but its very helpfull cause i just started to use access ty
好的，正如我猜测的那样。您应该拥有一个包含三个字段的表：lnumber，stdate和Document。 Document字段将是文档之间的分隔符，而不是具有单独的表。然后你的问题变得非常简单。
Okay, it is as I guessed. What you should have it one table that has three fields: lnumber, stdate, and Document. The Document field would be the divider between the documents instead of having separate tables. Then your problem becomes very simple to solve.
这篇关于返回表单的搜索表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
