如果Drop = A，则将一个字段链接到另一个表中的字段（从另一个DB链接） [英] Link one field to a field in another table (linked from another DB) if the Drop = A

问题描述

我有一个链接到我的新数据库的数据库表。我无法编辑链接表。所以我创建了另外一个带有附加数据的数据库但是我仍然需要将数据从一个数据提取到另一个数据。


我的数据库有2个字段

A：操作类型（这是一个下拉列表）和B：操作日期。

我需要将操作日期提取到链接表延迟日期。如果Action Type = Delayed。


如果我能得到第3个字段原因从Actiont Type中选择的内容进行过滤。那太好了。谢谢！

I have a DB table that is linked to my new DB. I can''t edited the linked table. So I created another DB w/ additional data however I still need to pull data over from one to the other.

My DB has 2 fields
A: Action Type (this is a dropdown)and B: Action Date.
I need to pull the Action Date over to the linked table "Delay Date" if the Action Type = Delayed.

Also if I could get a 3rd field "Reason" to be filted by what is selected from Actiont Type. That would be great. Thank you!

推荐答案

苏珊，我很害怕你希望实现的目标并不是很清楚。您是在寻找要在表单上显示的链接数据还是用于填充新数据库的旧数据库中的现有数据？


在任何一种情况下，有关字段的一些基本信息（和/或控件）有用。


欢迎来到 Bytes ！

Susan, I''m afraid it isn''t very clear what you are hoping to achieve. Are you looking for linked data to be displayed on a form or for existing data from the old DB to be used to populate your new one?

In either case some basic information about the fields (and/or controls) involved would be useful.

Welcome to Bytes!

我需要拿我的子表单中的操作日期Intake并将其放在主表格主数据库中的进入延迟字段中。问题是操作类型（从子表单设置标准。

如果我为操作类型选择延迟并在操作日期中输入日期我需要该日期链接到主表格中的Intake Delayed字段。


我希望我帮忙解释一下。谢谢！

I need to take the Action Date from my sub form "Intake" and place it in the Intake Delay field in the Master form "Main DB" the issue is that the Action Type (from the sub form sets the criteria.
If I select "Delayed" for the Action Type and put a date in the Action Date I need that date to link to the Intake Delayed field in th master form.

I hope I helped explain it. Thank you!

表A（主）

表B（子）

字段A.1（进入延迟日期）

字段A.2（进入完成）

字段B.1（操作类型 - 这是下拉列表）

字段B.2（操作日期）


如果B.1 =延迟然后B.2将链接到A.1


我还必须有IF B.1 =完成然后Al是空白和B.2（仅用于完成） action）与A.2

table A (master)
table B (sub)
field A.1 (Intake Delay Date)
field A.2 (Intake Completed)
field B.1 (Action Type--this is a Dropdown)
field B.2 (Action date)

IF B.1= "Delayed" then B.2 will link to A.1

I also have to have IF B.1= "Done" then A.l is blank and B.2 (only for Done action) is linked to A.2

这篇关于如果Drop = A，则将一个字段链接到另一个表中的字段（从另一个DB链接）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！