Linking tables using Query

[Guest]

Hi there,

I am working on a database to manage unlokcing reuests for handstets.

I have 2 tables:
Requests
IMEI
MSISDN
Name

Handstets
Manufacturer
Model
Prefix

The Prefix is the 1st 6 digits of an IMEI and lets us know what model the
handset is. I am able to create a query to identify each IMEI as it is keyed
into a table however am unable to create a relationshiq query back over.. I
cna chive part of my objective but it either wont allow me to edit or delete
records,

I have created a query to pair the handset IME and model togeater nd likned
ti to the requets this allows me to dril down form model to IMEI to request.

I would like to be able to drill down form Model directly to request and be
able to ammend the records where appropriate

I would be greatful of any help

Yhanks

 

[Guest]

Sorry igogot to metnion a handset can have more than one prefix i.e. Nokia
6600 can start 353798, 353777, 353383 or 351525

Thanks