如何在导入数据后填充MS Access 2007中的外键字段？ [英] How to populate foreign key field in MS Access 2007 after import of data?

问题描述

我对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.

推荐答案

您的问题不包含确定答案的逻辑。

Your question includes no logic with which to determine an answer.

我不确定您是否理解了问题配对。

I am not sure if you have understood the problem mate.

我试图了解如何将父记录与子记录链接起来。我试图在将数据上传到表格后链接父子记录。

i am trying to understand how do i link the parent record with the child records. i am trying to link the parent child records after uploading the data to the tables.

这篇关于如何在导入数据后填充MS Access 2007中的外键字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！