With ieach IMEI being entered onto the database being unique i have set
REQimei as a primary key. In the Prefix List table i have also made the
prefix the primary key.
as each prefix is unique.
A relationship would work normally however witht the IMEI being 15 digits
and the prefix only being 6 (or the 1st 6 digits of the IMEI).

Te database is to be used for the
" wrote:

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
.