Thread: Relationship
View Single Post
  #2  
Old February 11th, 2005, 02:30 PM
external usenet poster
 
Posts: n/a
Default

hi,
it is to my understanding that you have to have a common
field to define a relationship like an index id or unique
identifier. you don't have a common filed in either table.
read up on relationships in help.

-----Original Message-----
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
.