=?Utf-8?B?c3Rvcm0gd2FyZGVu?=
wrote in :

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

Requests
REQIMEI (15 digit serial number)
Customer Name

Handsets
Manufacturer
Model
Prefix (6 digit prefix)


It depends on the nature of the relationship. If each handset is the
subject of one request (but a request can address lots of handsets), then
you'll need to put the RequestNumber field in the Handets table. If each
request concerns one handset (but a handset can be requested lots of
times), then you'll need the HandsetID field in the Requests table.

I think you have already had some advice about storing the IMEI number
when it is made up of two parts, the 6-digit Prefix and the 9-digit
Remainder. Is there a reason you decided to take no notice of that?

HTH


Tim F