问题描述
我对Access 2007有疑问，
我会给你一个例子..
表A包含以下字段：
ProcessID - PK
高级流程名称
流程所有者名称
---- -
-----
等
表B字段
DetProcessID - PK
ProcessID - FK
详细流程名称 -
活动
------ -----
----------等
我已经从两个表中的电子表格上传了数据。挑战是如何填充表B中的ProcessID列？
我将两个表中的ProcessID字段链接为1对多关系。表A中有大约50个高级进程名称，表B中有近500个详细进程名称。
请指教。
I have a question on Access 2007,
I will give you an example..
Table A has the folowing fields:
ProcessID - PK
High level process names
Process owner name
------
-----
etc
Table B fields
DetProcessID - PK
ProcessID - FK
Detail process names-
Activitiy
-----------
----------etc
I have uploaded the data from spreadsheet in both the Tables. The challenge is how do I populate the ProcessID column in the Table B?
I have linked ProcessID fields in both tables as 1 - to Many relationship. There are around 50 High level process names in Table A and almost 500 Detail process names in Table B.
Kindly advise.
推荐答案
这篇关于如何在导入数据后填充MS Access 2007中的外键字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！