在第二个表的其他列中自动更新相应的行数据 [英] Autoupdate corresponding row data in other columns of Second table

问题描述

我有2张桌子。表1是具有字段名称的Excel导入日期。 "学校" Roll No 。在表2中，字段为Sl.No。 "姓名" "学校" Roll No 其他信息。我希望如果在表2中，我从表2的查找列中选择名称数据学校。 ，Roll No自动相应更新。请帮帮我

I have 2 Table . Table1 is Excel imported date having field "Name" "School" "Roll No" . In table 2 having field "Sl.No" "Name" "School" "Roll No" "Other Information". I want that If in Table2 ,I select the Name from Lookup Column of table 2 Data the "School" , "Roll No" automatic get updated accordingly. Please help me

推荐答案

从您的说法看，您似乎需要在适合您情况的两个表上运行更新查询。在你的问题中确实没有什么有用的信息，所以很难提供很多帮助，但基本原理是这样的，所以请告诉我们你是如何得到的。


如果您需要更多帮助，那么您需要向我们提供一个更有意义的问题。

From what you say it seems like you need to run an update query on your two tables at a time appropriate to your situation. There is really very little helpful information in your question so it''s hard to help much, but the fundamentals are there so get to it and let us know how you get on.

If you need more help then you''ll need to provide us with a question that makes better sense.

我试图用一个例子来理解。我有一个带有First_Name列的日期表" Middle_name"和Last_Name。我想创建另一个表，其中将有列First_name ，Middle_Name， "姓氏"和一些额外的领域。我将选择New tables" First_name"列作为查找wiziard并从表1中获取日期如first_name" ;.在新表中Middle_name的过程是什么？ "姓氏"可以从表1中选择日期，同时从下拉列表中选择第一个名字

I am trying to makeunderstand with an example. I am having a date table with column "First_Name" "Middle_name" and "Last_Name". I want to make another table where there will be column "First_name" , "Middle_Name" " Last_name" and some additional field. I will choose the New tables "First_name" column as a lookup wiziard and take the date from Table1 " First_name". What is the procedure that in the new table the "Middle_name" "Last_name" can take date from Table1 while choosing the first name from drop down

bctra：

我不打算听起来无意义;但是，你的第一篇或第二篇文章都不是很清楚。但是，从我收集到的内容中你真的需要访问这两个链接：


开头：访问教程


然后根据您的描述，您的数据库非常需要规范化：数据库规范化和表结构。 因为在两个或多个表中存储相同的信息绝不是一个好主意。

bctra:
I don''t intend to sound mean in anyway; however, neither your first or second posts are very clear. However, from what I can gather you really need to visit the these two links:

Start with: A Tutorial for Access

Then from what you describe your database is in serious need of normalization: Database Normalization and Table Structures. as it is never a good idea to store the same information in two or more tables.

这篇关于在第二个表的其他列中自动更新相应的行数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！