请访问关系帮助 [英] Access Relationship help please

问题描述

这是一个非常好的网站，我想感谢mdoerators和网站管理员进行维护。这是我的第一篇文章;我希望有人可以提供协助。


我正在为我的妻子建立一个数据库。我从一个定义标题的程序中提取报告：SSN，NAME，DOB，PR EPR，Last EPR，SUPER等。


主管= SUPER和SSN =他们的社交安全号码


当我提取数据时，Super会出现一个社会安全号码。我需要建立一个通过他们的名称识别SSN的关系或查询。


我只能以设定的方式下载主数据，我的链接表没有调整数据库。


示例：

This is a very nice site and I''d like to say thank you to the mdoerators and site administrator for maintaining. This is my first post; I hope someone can assist.

I''m working on a database for my wife. I pull reports from a program that defines the headings: SSN, NAME, DOB, PR EPR, Last EPR, SUPER, etc..

The supervisor = SUPER and the SSN = their Social Security Number

When I pull the data, the Super comes out with a Social Security Number. I need to establish a relationship or query that identifies the SSN by their NAME.

I can only download the main data in a set manner, there are no adjustments to the linked table in my database.

Example:

展开 | 选择 | Wrap | 行号

推荐答案

Hi MooseMan


隐藏报告中的SUPER字段但不要将其删除。现在添加一个新文本框并将控件源设置为

Hi MooseMan

Hide the SUPER field on the report but don''t remove it. Now add a New text box and set the control source to

展开 | 选择 | Wrap | 行号

谢谢Mary！我会试一试。

Thank you Mary! I''ll give it a try.

我按照建议尝试但没有用，我没有运气。还有其他建议吗？

I tried as suggested but to no avail, I had no luck. Any other suggestions?

这篇关于请访问关系帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！