Forum Moderators: open
customer
-----------------------
customer_id
customer_name
tel
contact
address
email
----------------------
shipping
------------------------
shipping_id
customer_id (FK)
customer_name
fee
shipping_date
------------------------
and I would like to write a shipping form for data entry, and I would like to let the user to select "customer_id", such as select c0001,c0002,etc... and then it will automaticlly display a customer name, such as John, Ann, Peter, Annie, etc.... in next line. Please help me, thank you so much!