使用其他两个表中的字段填充表 [英] Populating a table with fields from two other tables
问题描述
我在Filemaker中有两个表格:
I have two tables in Filemaker:
-
tableA
其中包括字段idA
(例如a123),date
,price
)和
tableA
(which includes fieldsidA
(e.g. a123),date
,price
) and
tableB
(其中包含字段 idB
(例如b123), date
, price
)。
tableB
(which includes fields idB
(e.g. b123), date
, price
).
如何创建一个新表, tableC
,字段 code>,用
idA
和 idB
填充(其他字段用于
How can I create a new table, tableC
, with field id
, populated with both idA
and idB
, (with the other fields being used for calculations on the combined data of both tables)?
推荐答案
唯一的方法是脚本)或者手动,如果这是一个ad-hoc过程。详情取决于情况,请澄清。
The only way is to script it (for repeating uses) or do it 'manually', if this is an ad-hoc process. Details depend on the situation, so please clarify.
更新:对不起,我其实忘了这个问题。我假设ID字段不重叠,即使跨表,并且您不需要多次添加同一记录,但更新它。在这种情况下,最简单的脚本如下:
Update: Sorry, I actually forgot about the question. I assume the ID fields do not overlap even across tables and you do not need to add the same record more than once, but update it instead. In such a case the simplest script would be like that:
Set Variable[ $self, Get( FileName ) ]
Import Records[ $self, Table A -> Table C, sync on ID, update and add new ]
Import Records[ $self, Table B -> Table C, sync on ID, update and add new ]
导入记录步骤通过相当详细的对话框,但是想法是从同一个文件导入(您可以键入 file:< YourFileName>
),格式为FileMaker Pro,然后设置字段映射。请务必选择更新匹配记录和添加剩余记录选项,然后选择ID字段作为要同步的密钥文件。
The Import Records step is managed via rather elaborate dialog, but the idea is that you import from the same file (you can just type file:<YourFileName>
there), the format is FileMaker Pro, and then set the field mapping. Make sure to choose the Update matching records and Add remaining records options and select the ID fields as key files to sync by.
这篇关于使用其他两个表中的字段填充表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!