MS Access：在组合框中显示两列(MS Access: Display two columns in combo

MS Access：在组合框中显示两列(MS Access: Display two columns in combo-box)

令人尴尬的简单问题，但我无法解决或通过谷歌找到答案。

有两个colums这样的东西

但是当它被选中时它只显示一列，使得信息更难阅读/理解。

尝试更改属性表中的属性（例如列号）但没有明显的效果。

Embarrassingly simple question but I can't work it out or find the answer via google.

Got something like this with two colums

But when selected it only displays one column, making the information much harder to read/ understand.

Tried changing properties in property sheet (such as column number) but to no apparent effect.

最满意答案

这在某种程度上取决于你在做什么，通常这样的事情适合：

SELECT Id, Surname & ", " & Forename from Table

换句话说，绑定列是唯一ID，选择列包括单个列中的姓氏和名字。

编辑基于其他信息：

SELECT [Contact].[CID], [Contact].[Csname] & ", " & [Contact].[Cfname] FROM [Contact] ORDER BY [CID], [Csname], [Cfname];

It depends to a certain extent on what you are doing, often something like this suits:

SELECT Id, Surname & ", " & Forename from Table

In other words, the bound column is a unique ID and the selection column includes both the surname and forename in a single column.

EDIT based on additional information:

SELECT [Contact].[CID], [Contact].[Csname] & ", " & [Contact].[Cfname] FROM [Contact] ORDER BY [CID], [Csname], [Cfname];