Dropdown list not working

[hendrikbez]

Using Access 2010
I have build a new form with textboxes and 5 dropdown list boxes.

I have make a main table where all the info must go into that it is getting from the vorm input.
I have also make 5 different tables were the info of the dropdown list is in.
I have make each dropdown list to get info form its table and then add it to main table.
But when I add info in my vorm and save it, on the vorm it shows the correct info, but on my main table
It shows the ID # for each dropdown list and not the info that I need.

Eg. Here is one of my tables

ID Client
1 Prasa
2 Data
3 Info
4 Piet
5 Jan

But it show in main table ID # 5 instead of Jan in the column Client
I have add the file to look at

 

[namliam]

Some issues with your database...
1) Naming convention
Strongly suggest you addopt a proper naming convention, have a read of the following
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=naming+convention
and try to addopt that
2) Having field names "Field1" is not exactly informative.

As to your question/problem, this is the way that things work and supposed to work. You store your information only in one place, like in your client table.... Then from your main table you "join" the key and foreign key from the two tables to find the information you need.

 

[hendrikbez]

Thank You, I would have changed the naming convention, was just testing.
This is a putty, as I need to send the main table out evry week, and that is only show the Id number is not good, How can I use it then to show the info that I need.

 

[namliam]

As to your question/problem, this is the way that things work and supposed to work. You store your information only in one place, like in your client table.... Then from your main table you "join" the key and foreign key from the two tables to find the information you need.

i.e. you make a query, add your main table and "combobox tables"
Then you "join" them (drag the field from your main table to your combobox table, make sure it is on the proper column)

Then you display the field from your combobox table where you hold the information you are actually intrested in.

 

[hendrikbez]

i.e. you make a query, add your main table and "combobox tables"
Then you "join" them (drag the field from your main table to your combobox table, make sure it is on the proper column)

I have done this see screenshot

Then you display the field from your combobox table where you hold the information you are actually intrested in.

This one I am not sure what you mean. I did add the dropdownlist from one of my combo tables, and still not showing. in my table when I open it.

 

[namliam]

It wont show in the table, ever.... the key is stored in the table, not your description.

Plus what you did is wrong, the ID is stored in your table thus you want to "join" on the ID not i.e. the Assignee

In the query you "drag" the Assignee from your Assignee table to the grid, allongside any other information you want/need and run the query...

 

[hendrikbez]

Namliam
I have treid to get this to worked, but cannot do you maby have a sample for me to look at

 

[namliam]

1) Change your datatype of client to "Numeric" instead of text
2) change the join from Client to Client to Client to ID

That should be the idea to fix this

 

[Mile-O]

Look at the attached. The form will let you put some sample data in. qryExample pulls all your data together.

 

[hendrikbez]

Mile-O Thank you for the sample

 

[Mile-O]

No probs. As long as you now understand what's happening.

 

[hendrikbez]

I am trying, but it is a bit confusing, I will go true it, but I have tried to add a normal text box, but It stop me from doing so, how do you add a column to a table that is been blocked