Combo box showing the primary keys instead of the value of the record

[Gameybeets]

Views: 7 Size: 444.0 KB">example.accdb

Hello,

I'm new to database and Access. I'm posting an example of what I'm trying to do here. In the example, I have the vendor table which keeps the record of all the vendors. In the late payment vendor table, I have vendors with late payment which I created with lookup wizard resulting in combo box. I did the same thing to termination table which I only want vendors used in late payment vendor table. When I do that, I no longer see the text value of the vendor name anymore, and now I only see the primary key of the vendor. How can I fix this?
The reason I have combo box in the table is to create a form later with the combo box already set up.
Any help is much appreciated!!!

[solly1966]

Hi, very simple.. in the form design mode, click the combo box field and in the property box, go to -> data tab -> Row Source -> Type SELECT [yrtable].[field1], [yrtable].[fielf2] FROM yrtable ORDER BY [primarykey]
after you entering this come to ->Format tab -> Column Count-> 2 and in column width enter 0 cm; 3 cm.

[orange]

I recognize that you are a self-confessed newbie to database and Access. I recommend that you work through this tutorial from RogersAccessLibrary, and then go back to you database. You will learn some concepts of design of tables and relationships, that you can use with any database. Should take 45 minutes to 1 hour.
This info on Normalization may also be helpful.
Do you have clear instructions in plain English of what you are trying to do/automate?

Good luck.

[Gameybeets]

Hi, very simple.. in the form design mode, click the combo box field and in the property box, go to -> data tab -> Row Source -> Type SELECT [yrtable].[field1], [yrtable].[fielf2] FROM yrtable ORDER BY [primarykey]
after you entering this come to ->Format tab -> Column Count-> 2 and in column width enter 0 cm; 3 cm.

Thank you. Does this mean I wouldn't be able to see this in a table? Is there anything wrong with the way I'm setting up my database?

[Gameybeets]

I recognize that you are a self-confessed newbie to database and Access. I recommend that you work through this tutorial from RogersAccessLibrary, and then go back to you database. You will learn some concepts of design of tables and relationships, that you can use with any database. Should take 45 minutes to 1 hour.
This info on Normalization may also be helpful.
Do you have clear instructions in plain English of what you are trying to do/automate?

Good luck.

Thank you for the reply.
I'm trying to limit the choice of the vendors for the termination table. The user should only choose from the vendors in late payment table instead of showing all the vendors from the vendor list.

[CJ_London]

duplicate post here

http://www.access-programmers.co.uk/...d.php?t=285177

@Gameybeets - recommend you read this link

http://www.excelguru.ca/content.php?184