访问表字段问题 [英] access table field question
问题描述
在一个简单的访问表中，希望FDL1和FDL 2自动生成
fld一个是设施号（5digit）
fld two是设施名称
表包含：字段名称，字段编号，收到的日期，编号，编号，选择1，选项1，选择2，选项2 ...选择3，选项3
当我可以收到有或没有设施号的信息.......所以当进入该行时，我希望能够使用组合框中的设施名称并且字段编号将自动出现在下一个字段中。
这将有助于验证分配的正确号码。
此表格将以子表格形式使用
请帮助，我找不到任何人来帮助解决这个问题。我能够将其用于起作用，但是在表格上进行更改是错误的，因为表格现在不起作用
新手试图保住她的工作谢谢提前
In a simple access table, would like for FDL1and FDL 2 to auto generate
fld one is facility number (5digit)
fld two is the facility name
Table contains: field name, field number, date received, number of, number without, selection 1, option 1, selection2, option 2 ...selection 3, option3
When I can receive info with or without the facility number.......so when entering the row, I would like to be able to use the facility name from the combo box and the field number will automatically appear in the next field.
This will help to verify the correct number is assigned.
This table will intimately be used in a sub form
Help please I cannot find anyone to help figure this out. I was able to get this to work on a from, but that was a mistake to make changes on the form, because the table do not work now
Novice trying to keep her job thanks in advance
推荐答案
表中实际记录的是什么值？所需要的只是来自设施表的ForeignKey。一个查询可以连接两个表，这样你就可以从任何一个表中看到你需要的任何字段。
What value is actually recorded in the table? All that is needed is a ForeignKey from the facility table. The a query can join the two tables so you can see whatever fields you need from either table.
FACNUM FACNAME RecDate方法ENTRYDATE NumCases NUMWITHtx OHYLTR NR案例总数1频率1站点2频率2站点3 Frequency3 Site 4 Frequency4 Notes
FACNUM FACNAME RecDate Method ENTRYDATE NumCases NUMWITHtx OHYLTR NR Total Cases Site 1 Frequency1 Site 2 Frequency2 Site 3 Frequency3 Site 4 Frequency4 Notes
您正在使用ComboBox填充此表中的字段。 ComboBox的RowSource的SQL是什么？BoundColumn和ControlSource值是什么？
You are using a ComboBox to populate a field in this table. What is the SQL for the RowSource of the ComboBox and what are the BoundColumn and ControlSource values?
这篇关于访问表字段问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
