Listbox displaying only numbers

[Isaac]

Alright Micron, I will defer to you and refrain from distracting about the list box. Good idea.

 

[rayape]

Have a look at this sample database.

Listbox displaying only numbers

Hello All - I have two tables AssetList and AssetInfo. Both tables have AssetID (field) as Primary Key. AssetList has all the names of Assets. AssetInfo has details for each asset (like serial number, model number and so on). AssetIDs are joined to form a relationship. I have a listbox in...

www.access-programmers.co.uk

I will sir. Thank you.

 

[Deleted member 147267]

How about I just throw everything out here given that I suspect it will all be news. Start with the normalization. If it doesn't sink in, find your own links that 'speak' to you. If you do not grasp normalization you will always struggle. I'm not saying you have to be a wizard at it, just understand enough to succeed.
Normalization is paramount. Diagramming maybe not so much for some people.

Normalization Parts I, II, III, IV, and V (make sure to follow the links - they're not obvious)

What Is Normalization, Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

and/or

Database Normalization – Holowczak.com Tutorials

holowczak.com

Entity-Relationship Diagramming: Part I, II, III and IV

Entity-Relationship Diagramming: Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

How do I Create an Application in Microsoft Access?

How do I Create an Application in Microsoft Access?

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

Naming conventions
- http://access.mvps.org/access/general/gen0012.htm
- https://www.access-programmers.co.uk/forums/showthread.php?t=225837

What not to use in names - http://allenbrowne.com/AppIssueBadWord.html

About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763

 

[rayape]

How about I just throw everything out here given that I suspect it will all be news. Start with the normalization. If it doesn't sink in, find your own links that 'speak' to you. If you do not grasp normalization you will always struggle. I'm not saying you have to be a wizard at it, just understand enough to succeed.
Normalization is paramount. Diagramming maybe not so much for some people.

Normalization Parts I, II, III, IV, and V (make sure to follow the links - they're not obvious)

What Is Normalization, Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

and/or

Database Normalization – Holowczak.com Tutorials

holowczak.com

Entity-Relationship Diagramming: Part I, II, III and IV

Entity-Relationship Diagramming: Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

How do I Create an Application in Microsoft Access?

How do I Create an Application in Microsoft Access?

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

Naming conventions
- http://access.mvps.org/access/general/gen0012.htm
- https://www.access-programmers.co.uk/forums/showthread.php?t=225837

What not to use in names - http://allenbrowne.com/AppIssueBadWord.html

About Auto Numbers
- http://www.utteraccess.com/wiki/Autonumbers
- http://access.mvps.org/access/general/gen0025.htm

The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763

Thank you

 

[so10070]

You make a lot of errors to define your relations.

• first of all: a primary key refers to a foreign key from the first table to the second one. You can't set a relation between two tables on the two primary keys
• you have to set a relation one to many between both tables: from table one primary key (autonumber) to table two (number field) (with the same name as the primary key of table one.
• then you have to create a query to fill the listbox
  

    sqlListOne = "SELECT Asset, SerialNo " & _
        "FROM AssetList INNER JOIN AssetInfo ON AssetList.IDAssetList = AssetInfo.IDAssetList;"

• then you have to activate the listbox

    With Me.lstOne
        .RowSource = sqlListOne
        .ColumnCount = 2
        .ColumnWidths = "3cm;2cm"
    End With

If this is what you want to see. Or else: create two form a parent and a child form.