Need help on ms access 2013 tables

[stereojack]

i recently create a table on MS Access for employee detail, in the employee form i want all the field in employee detail be as reference list for dropbox or listbox for other table, and store it again on different table. please advise me how to create one.


i stuck on doing the relating the table from other table and storing the data on different table instead of storing data on employee detail.

[June7]

What are 'other table' and 'different table'?

Building comboboxes on form is basic Access functionality. There's even a wizard to walk you through the process. What exactly do you not understand about doing this?

[stereojack]

what i mean is, i want to create a form that takes data from employee detail such as position in listbox, after clicking the selected position and fill the rest textbox then save it, but i want it store data on different table instead of in employee detail

[June7]

I suggest the only value that should be saved in record of 'different' table is the EmployeeID. Otherwise, you are duplicating data and that is violating relational database principles.

[stereojack]

is there any way to create table for listing purpose for listbox only?

[June7]

Not sure what you are asking.

Certainly a table can be the source of items for a combo or list box. Such as table of colors. This table could have a single field and a record for each color. The combobox RowSource could be:

SELECT color FROM Colors ORDER BY color;

[stereojack]

i want table for listbox only, not a table for saved data. i want it to be in dynamic table. instead of using one single table for all storing data.

[June7]

I think that's what I described with my example of a table for colors.


You might need a better understanding of relational database principles. See if this helps http://www.rogersaccesslibrary.com/