导入表另一个表中的字段定义 [英] Import table Fields definitions from another table

问题描述

您好！祝大家圣诞快乐/节日快乐


我有一张名为Positions的大桌子。超过160个字段，其中字段以非明显缩写命名。

我有另一个名为definitions的表其中包含列名和定义字段。


为了帮助我完成我未来的发展，我想从表格定义中使用这些定义。进入职位。当然，我可以逐个手动复制每个定义但是存在错误的风险，并且表格位置也是如此。可能会由提供给我们的一方更新......所以在这种情况下，长期自动可能更好。


有什么自动选项？

- 导入一次？

- 是否可以链接位置的描述字段？用定义和定义桌子？


提前感谢你输入的人。

祝你好运

Hello! Happy Christmas/holidays to you all

I have this huge table named "Positions" with more than 160 fields of which the fields are named with non obvious abbreviations.
I have another table named "definitions" which has the column name and definition fields.

In order to help me all along my forthcoming developments, I would like to use these definitions from table "definitions" into "Positions". Of course i can manually copy each definition, one by one but there is a risk of error and also, the table "Positions" might be updated by the party which delivers it to us... so automatic might be better over the long term in this case.

What are the automatic options?
- Import once?
- Is it possible to link the description field of "Positions" with the "Definitions" table?

Thank you in advance for your input guys.
Best regards

推荐答案

那么在表格定义中你有160个位置中的其他字段吗？

你想把这些文件从定义添加到职位......


如果它们的大小那些字段你可以有一个带访问权限的pb！ Access表中不能超过255个字段！并且可以告诉你，如果你有超过220个领域你会遇到问题...


所以我认为在位置导入更多字段不是一个好主意。


所以我的建议......


创建tirth表并在此表中创建3个字段：


ID_Position，ID_definition和Value


在这个结构中，你可以介绍你拥有的每个位置和定义的信息！


这有用吗？

So i n the table definitions u have other fields out of those 160 in Positions?
and u want to add those fileds from definitions to Positions...

If they a large size those fields u can have a pb with Access! There can''t be more than 255 fields into an Access table! And can tell u that if u have more than 220 fields u will have problems...

So i don''t think as a good idea to import more fields in Positions.

So my suggestion...

Create tirth table and in this table create 3 fields:

ID_Position, ID_definition and Value

In this structure u can introduce info for each position and definition that u have!

Is this helpful?

表" position"由160个字段组成，但没有字段定义

我希望通过从表格defintions中导入来自动添加这些字段的定义

表定义包括以下字段：

" Field"实际上与位置相匹配表字段名称。

和定义


谢谢你

Table "positions" is made of 160 fields but there are no field definitions
I am looking to add automatically the definitions of these fields by importing them from table "defintions"
Table definitions includes the following fields:
"Field" which actually matches the "positions" table fields names.
and "definition"

THank you

表职位由160个字段组成，但没有字段定义

表定义包括以下字段：

" Field"实际上与位置相匹配表字段名称。

和定义


谢谢你

Table "positions" is made of 160 fields but there are no field definitions
Table definitions includes the following fields:
"Field" which actually matches the "positions" table fields names.
and "definition"

THank you

你做什么字段定义下的平均值？验证规则，密钥，索引，验证文本，大小？每个字段的所有属性都可以视为字段定义！那么告诉我你想要自动更新的字段属性是什么？

主要以编程方式完成字段创建！创建字段后，我将检查Access帮助中的TableDef属性以获取更多信息！

What do u mean under field definition? Validation Rules, Keys, Indexes, Validation text, Size? All of those properties of each field can be considered as Field definition! So tell me what property of the field u want to update automatically?
Principally programatically can be done while the field is created! When the field is created i''ll check TableDef properties in Access help for more info!

这篇关于导入表另一个表中的字段定义的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！