Lookup Fields in tables (1 Viewer)

[kerrydunk]

Hi there
I have a database with various tables, customers, jobs_table, black_book.
I am wanting to have a field that looks up a latest date.

Both the [jobs_table] and [black_book] have a date field, there can be multiple entries per customer in both fields. What I want to do is have 2 fields in the [customer] table that looks up the customer name in [jobs_table] and [black_book] and brings back the latest date.

Hoping someone can help
Thanks in advance

 

[Alansidman]

Do your lookups from a Form. Read here:

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