ACCESS COMBO

[John]

I NEED YOUR HELP


I create employee table : Employee Name
Address in Table.
item table : Item No
Item Name in Table
pay table : Employee Name
Address
Item No
Item Name


create Issue table : Employee Name
Address
Item No (combo - dropdown)
Item Name (link with item no) in Form

start use Issue table to key-in data
Employee Name - manual type
Address - manual type
Item No - dropdown combo to select
Item Name - auto pop-up
after updating, go and open issue table, except item name are updated. how
could we update item name.

Thanks

JOHN

 

[tina]

you're duplicating data in multiple tables (employee name in two tables,
address in two tables, item name in two tables), which is a violation of
data normalization rules. recommend you stop now, before you get in any
deeper, and read up on data modeling. for more information, see
http://home.att.net/~california.db/tips.html, beginning with Tips 1 and 2.

hth