I have an access db with two tables (i.e. Ta, Tb) where records of Tb relate to records of Ta. When a new record in Ta is created I need to automatically create a new empty record in Tb which relates to the new Ta record. What is the easiest way to do this?
谢谢。
一般来说,你会利用数据库的触发点来做到这一点。 不幸的是,我不认为管理上无障碍支持触发因素。 如果你能够使用MSQ,那么你就可以使用触发器。
我发现this post: 讨论一些替代方法,以完成你所期待的工作。
进出通道储存了程序,但可以使用。
After_Insert. event then run an insert query.
在塔克总公司挑选一名候选人,以获得最大补偿,以便你能够在塔布这样做
From Ribbon:
将下列领域列为问答领域
注 独一无二的相关领域(例如UniqueID)和。
1.2.2. www.un.org/spanish/ga/president
1.3 Save (e.g., QueryA)。
So there are at least 4 query fields in QueryA now (UniqueID from Ta, UniqueID from Tb, FieldX_Ta1, FieldY_Tb).
在导航板上选取QueryA
2.1 2.1 FieldX_Ta和的设定违约值 FieldY_Tb。
2.2 设计是理想的和“拯救儿童”(例如,Form_I)。
3.1 基本健康 进入“新记录”。
页: 1 表格。 一旦“拯救儿童”组织,“Ta和tb就应当有通过Unique链接的新记录。
[使用MS Access FCCC/SBI/2008/12号文件]。
I am copying a record from one table to another in Access 2007. I iterate through each field in the current record and copy that value to the new table. It works fine until I get to my lookup column ...
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...
I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...
On a continouos form in ms-access, I have a record source similar to select col_1, col_2 & " " & col_3 as col_expr from tblFoo and then I have bound col_expr to a text box on that form....
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...
