帮助：表单不更新 [英] HELP: Form Is Not Updating
问题描述
hi
这是我发给电子脚本的第一篇文章。我希望我能尽快得到帮助。
我有2张桌子员工，第二张是培训。它们之间的关系是1比1.我在查询qrysg中联合了两个表字段。从那个查询中我已经制作了一个表格。
现在的问题是每当我在表单中添加新记录时，（我只是填写员工的表字段并离开培训'暂时表格字段为空）...然后我保存条目或表格然后关闭它。之后，当我再次打开表单时，我看不到表单中的新条目。当我检查表格时，我看到在员工表中已经创建了新条目，但在培训表中没有。当我在员工表中输入数据时，帮助我找到一个解决方案，培训表显示更新。
员工表培训表
--SG否（自动号码） - 培训号码（自动号码）
- 职位名称（文字） - 警察身份证号码（号码）
- 姓名 - 入职培训（是/否）
- 国籍 - 基于网站的培训（组合框）
-----------
-------------
hi
Its my first post to e-scripts. i hope i will get help soon for my problem.
I have 2 tables Employees and the second one is Training. The relation between them is 1 to 1. i have joint the two table fields in a query "qrysg" and from that query i have made a form.
Now the problem is that whenever i put a new record in the form, (i just fill up the employee''s Table fields and leave the Training''s Table fields empty for the time being)...and i save the entry or form then i close it. After that when i open the form again i do not see that New Entry in the form. When i check the Tables then there i see that new entry has been made in Employees Table but not in the Training Table. HELP ME OUT in finding a solution that Training Table show update itself when i enter the data in the employees table.
Employees Table Training Table
--SG No (Auto Number) --Trainee No (Auto Number)
--Job Title (Text) --Police ID (Number)
--Name --Induction Training (yes/no)
--Nationality --Site Based Training (Combo Box)
-----------
-------------
帮助
Help
推荐答案
请你发布查询的SQL。这将是第一件要看的事。
Can you post the SQL of your query please. That would be the first thing to look at.
我还添加了第三个表名为SG Security
第三个表是SQL
I have also added a third Table to it names "SG Security"
with this third table following is the SQL
请问您是否可以解决方案？
Please if u can fine me a solution?
这篇关于帮助：表单不更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
