查询数据时将昵称转换为全名 [英] Convert nickname to fullname when querying data

问题描述

我有一个提供商表，其中包含许可证号和全名字段等。如果我有新的条目，如果昵称表中存在昵称，Deman帮助我能够输入昵称并将其更改为全名。我还有一个名为TA的表，我在其中输入请求，使用许可证号链接到providers表。 （fullname字段仅存在于providers表中。）我希望能够通过输入昵称（因为它存在于昵称表中）而不是输入fullname来查询TA表中的请求。有人可以帮忙吗？在此先感谢。

I have a table of providers that has a license number and fullname field, among others. Deman helped me with being able to enter a nickname and having it change to the fullname if a nickname exists in a nickname table when I have new entries. I also have a table called TA where I enter requests, linking to the providers table with the license number. (The fullname field exists only in the providers table.) I''d like to be able to query the TA table for requests by entering the nickname (as it exists in the nickname table) rather than entering the fullname. Can anyone help? Thanks in advance.

推荐答案

在以相关方式链接表之后，您应该能够在查询中执行此操作。您的问题目前还不够明确，无法提供直接答案。

如果您发布Meta-Data表格，我们可以为您提供更多信息。

这是一个示例如何发布表元数据：
表名= tblStudent

You should be able to do this in a query after linking the tables in the relevant way. Your question is not currently clear enough to provide a direct answer.
If you post the table Meta-Data we can probably get you further with this.
Here is an example of how to post table MetaData :
Table Name=tblStudent

展开 | 选择 | Wrap | 行号

I对不起，我几乎是个新手。我不确定我是否了解Meta数据。这是吗？


顺便说一下，我有三张桌子：

桌面名称= [持牌提供商]

I''m sorry, I''m pretty much a novice. I''m not sure I understand about Meta-data. Is this it?

I have three tables, by the way:

Table Name=[Licensed Providers]

展开 | 选择 | Wrap | 行号

确实（有点）有意义。

我现在的困惑是你的输入搜索字符串。您谈到运行（可能是SELECT）查询，但没有提及表单或其他此类过滤或搜索方法。

可以创建SQL以链接NickName内容，但是我需要更好地理解你在做什么才能知道建议什么。

一个好的开始就是发布你当前查询的SQL。请使用提供的[code]标签（＃）。它为我节省了之后添加它们的工作;）

It does (sort of) make sense.
My confusion now is how you''re typing in a search string. You talk of running a (presumably SELECT) query, but there''s no mention of a form or other such method of filtering or searching.
The SQL can be created for linking in the NickName stuff, but I''d need a better understanding of what you''re doing with it to know what to suggest.
A good start would be to post the SQL of your current query. Please DO use the [code] tags (#) provided. It saves me the job of adding them for you afterwards ;)

这篇关于查询数据时将昵称转换为全名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！