插入？删除？更新？ [英] Insert Into? Delete? Update?

问题描述

Access 2003我对此非常陌生......

我创建了一个资产和软件许可证跟踪数据库。（我使用创建的字很松散）


tbl_Assets

field_EmployeeID（从查询表中拉出）

field_StatusID（CheckBox）


tbl_Software

field_EmployeeID（从查询表中拉出来）

field_StatusID（CheckBox）


我只列出了我认为相关的字段


下面的表单显示用户的所有已分配资产和软件许可证。


frm_AssignedAssets

状态有效/无效（组合）


它有3个数据表子表格及其信息。


它们是：


分配的资产（数据表）

资产升级（数据表）

软件许可证（数据表）


场景是我将frm_AssignedAssets上的状态从Active更改为Inactive

我想删除tbl_Assets.EmployeeID并将

tbl_Assets.StatusID中的值更改为是和tbl_Software相同


令人困惑？


我一整天都在弄乱这个，虽然这对一些人来说似乎很容易，但我不能为我的生活找到正确的方法。


我以为将使用ondirty

如果我！Status.Inactive = True那么？

无论我跟随什么都没有用...这可能完全是offbase ...


非常感谢任何帮助。 ：）

解决方案

我很难跟踪这是什么。

我理解其中一些，但不是如何数据合在一起:(

你能发布你的表格结构（请随意忽略以前任何不相关的字段）所有相关表格以及每个表格的指示（PK; FK;等）以下是您可以遵循的示例表MetaData布局：

发布表/数据集元数据

展开 | 选择 | Wrap | 行号

我很难跟进这一切。

我理解其中一些，但不是数据如何组合在一起:(

你能发布你的表格结构（请随意忽略任何不相关的字段），因为所有相关的表格以及指示（PK; FK;等）每个如何链接到任何其他人。以下是您可以遵循的示例表MetaData布局：

发布表/数据集元数据

展开 | 选择 | Wrap | 行号

是的，我希望有一些更直接的东西:(

但是，有些问题并不简单 - 你能做什么？

假设我需要的一切都在这里，我稍后会看看是否可以找到适合你的东西。如果没有，我会发布我需要的东西。

Access 2003 I am very new at this...
I have created an Asset and Software License Tracking Database.(I use the word created very loosely)

tbl_Assets
field_EmployeeID (Pulled from a lookup table)
field_StatusID (CheckBox)

tbl_Software
field_EmployeeID (Pulled from a lookup table)
field_StatusID (CheckBox)

I only listed the fields I felt relevant

The form below displays all assigned assets and software licenses for a user.

frm_AssignedAssets
Status Active/Inactive (Combo)

It has 3 datasheet subforms with the information.

They are:

Assigned Assets (Datasheet)
Asset Upgrades (Datasheet)
Software Licenses (Datasheet)

The scenario is when I change the Status on frm_AssignedAssets from Active to Inactive
I would like to remove the value from the tbl_Assets.EmployeeID and change the value in
tbl_Assets.StatusID to Yes and the same for tbl_Software

Confusing?

I have been messing with this all day and although this may seem easy to some I cannot for the life of me figure out the correct way to do it.

I thought it would be using the ondirty
If Me!Status.Inactive = True then ?
whatever I follow with has not worked...This maybe completely offbase...

Any help is greatly appreciated. :)

解决方案

I''m having difficulty following what this is all about.
I understand some of it, but not how the data fits together :(
Can you post your table structure (please feel free to ignore any irrelevant fields as before) for all the relevant tables as well as indications (PK; FK; etc) of how each links to any others. Here is an example table MetaData layout that you could follow :

Posting Table/Dataset MetaData

Expand|Select|Wrap|Line Numbers

I''m having difficulty following what this is all about.
I understand some of it, but not how the data fits together :(
Can you post your table structure (please feel free to ignore any irrelevant fields as before) for all the relevant tables as well as indications (PK; FK; etc) of how each links to any others. Here is an example table MetaData layout that you could follow :

Posting Table/Dataset MetaData

Expand|Select|Wrap|Line Numbers

Yes, I was hoping for something a little more straightforward :(
However, some problems are just not simple - What can you do?
Assuming everything I need is here, I''ll have a look later on to see if I can find something for you. If not I''ll post what I need.

这篇关于插入？删除？更新？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！