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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMBO 2
Access 2003 Lookup Lists 1
combo box source 4
Sorting data 3
Invoice database / report question. 7
Service Work Order Form 0
List Box or Combo Box Problem 3
automatically updating a table 8

Back
Top