Linking form fields to table data

  • Thread starter Thread starter tjs-81
  • Start date Start date
T

tjs-81

Guest
Hi Guys,
Haven't done anything with Access since I finished uni and I can't remember much. I'm trying to set up a simple database with customer recording and order taking functionality. Just in the very early stages trying to get basic things working.

I have a form where you enter customer details..at the bottom there is a command button named "Place Order", which will be clicked to go to the order form for that customer. Attachement shows very simplified version of the order form. I need to enter a Product ID, and have the Product Name automatically extracted from the Products table.

How can I do this? I would have done a search...but not even sure what this process is called in Access.
Thanks for any help.
 

Attachments

  • order.jpg
    order.jpg
    18.5 KB · Views: 151
hello
i suggest you go throgh the Northwind database sample

it has an excellent form for customer and order.
you can find it in
Program file --> ms office --> Samples

Or simple do a search in yiour computer for northwind

start --> find file and folder .--> type northwind

hope this helps
 

Users who are viewing this thread

Back
Top Bottom