ACCESS COMBO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top