Thread: Relationship
View Single Post
  #1  
Old February 11th, 2005, 03:01 PM
storm warden
external usenet poster
 
Posts: n/a
Default Relationship

Is it possable to set up a relationship between two different tables.

Requests
REQIMEI (15 digit serial number)
Custoemr Name

Handsets
Manufacturer
Model
Prefix (6 digit prefix)

What i would like to do is to stetup a form whreby the handst model is
displayed each time an IMEI is entered. I have set up a dlookup function but
it only shows the mdoel when the form is closed then re-opened

Some help would be appreciated

Thanks