Others

How to Display Company Name Instead of ID in Microsoft Access

Natalie Taylor Oct 15, 2026 869 views

Question details

The user needs to store a company's ID as a foreign key in a database table but display the actual readable company name to users via forms or queries.

How to Display a Company Name Instead of Its ID in Microsoft Access

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing a relational database form or query where users need to interact with readable text (Company Name) instead of the stored numeric values (Company ID).
Observed behavior: Ensuring the database remains consistent by storing only the unique ID in related tables, while visually displaying the corresponding company name without creating duplicate data entries.

Before you start

Verify that your tables have correctly defined primary keys (such as AutoNumber for CompanyID) and that the foreign key in your linked table is set to a standard Number data type (Long Integer), not Large Number.

Solution 1Recommended

Configure a Two-Column Combo Box in Forms

Use a combo box on your form with custom column widths to hide the numeric ID and display the readable company name.

By setting the column widths appropriately, Microsoft Access can store the bound column (the ID) in the underlying table while visually showing the second column (the company name) to the user.

Access the Property Sheet

Open your form in Design View, select the target combo box, and press F4 to open the Property Sheet.

Set the Row Source

Navigate to the Data tab and set the Row Source to: SELECT CompanyID, CompanyName FROM tblCompanies ORDER BY CompanyName;

Assign the Bound Column

Still in the Data tab, ensure the Bound Column is set to 1. This ensures the CompanyID is the value saved to your table.

Adjust Column Widths

Switch to the Format tab. Set the Column Count to 2, and change the Column Widths property to 0;1 (or 0";1"). This hides the first column (ID) and displays the second (Name).

Configure a Two-Column Combo Box in Forms

Data Integrity: This method ensures the numeric CompanyID is securely saved in your database while providing a user-friendly interface.

Solution 2

Use Query Joins for Datasheet Views

Create a relational query to link tables and display the company name alongside related records in datasheet views.

Free Microsoft Office alternative

Looking for a Lightweight and Free Office Suite?

While Microsoft Access is used for complex database management, for your everyday document processing, spreadsheets, and presentation needs, WPS Office offers a powerful, highly compatible, and free alternative to Microsoft Office. Enjoy a familiar interface and seamless migration without the heavy subscription fees.

1. Download and Install: Get the free WPS Office installer from the official website and complete the quick installation process.
2. Open Your Files: Directly open your existing Word, Excel, or PowerPoint documents—no format conversion is required.
3. Edit and Save: Edit your work using familiar tools and save them in standard formats like .docx and .xlsx to share with others.

Free and lightweight alternative to heavy Microsoft Office subscriptionsSeamless compatibility with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Familiar user interface requiring almost zero learning curveBuilt-in PDF editing, merging, and conversion toolsCross-platform support for Windows, Mac, Linux, and mobile devices

microsoft office alternative - wps office

Frequently Asked Questions

Why shouldn't I just save the company name directly in my data table?

Storing the company name directly in a secondary table creates redundant data. If a company changes its name, you would have to update it in every single record. Storing a unique ID prevents data inconsistencies and follows database normalization rules.

Why do I get a 'no unique index found' error when creating a relationship?

This error occurs if you try to enforce referential integrity on a field that isn't a primary key or doesn't have a unique index, such as a Company Name field. Table relationships should always be linked using the Primary Key (like CompanyID).

Should I use the 'Large Number' data type for foreign keys?

No, unless specifically required by extremely large datasets. It is best to match an AutoNumber primary key with a standard Number data type (specifically set to the Long Integer subtype) for your foreign key to ensure proper relationship enforcement.

Can I sort the combo box dropdown alphabetically by company name?

Yes. By adding 'ORDER BY CompanyName' to your combo box's Row Source SQL statement, the dropdown list will automatically sort the names alphabetically, making it much easier for users to find the right company.

Office Quick Solutions