lookup help please

[RRMESLTD]

Help needed please with ‘ACCESS’ look up,

I basically have 2 tables on a database I have created which when we enter the data via a simple form I wish for some of the ‘manual typing’ to be replaced buy using lookup to auto fill some fields.

The form & main table (orders) has the following fields, all I want to do is ‘auto fill’ the supplier name when we add our supplier code to the form. The data which contains the supplier names is in the ‘Active Supplier Table’


Orders Table*************Active Supplier Table

OrderID*****************Supplier Code
Supplier Code************Supplier Name
EmployeeID
OrderDate
Supplier Name


Also, is it possible for the ‘Orderdate’ field to be completed with the date the record was added. Any help would be greatly appreciated.

 

[mdmilner]

For starters, don't use Lookup Fields:

http://www.mvps.org/access/lookupfields.htm

It's easier to build a relationship between the two tables and then use a query or SQL to display the joined data.

Mike

 

[RRMESLTD]

thanks, I'll give it a go


regards
Mark

 

[RRMESLTD]

ok, i have created the relationships on the tables & the supplier number appears on the 'form' for data entry.. When I save the new record the suppliers name is not added to the main database ?? any suggetsions

 

[mdmilner]

It won't be.
What you'll need to do is set up a many-to-one relationship between the main table and the 2nd (the one you wanted to do a lookup on)

Second step is to build a query based on the two tables and stop using the table entirely. The query will become your recordsource for forms, other queries, reports, etc.

Mike

 

[RRMESLTD]

ok, can you pint me in thr right direction to building the query(sorry for all the questions)