relationship query

G

Guest

Hi there

I ahev created a database wite two tables whith which there are tow fields i
would litke to create arelationship between

table 1 - requests
Contains IMEI, mobile No. & Name

table 2 handsets

Prefix
Model

I would like to create arelationship between the IMEI and prefix for examble
an IMEI is the 15 digit serial number of a mobile phone e.g. 35005000000000
this is a Nokia 3510. The prefix of this is the 1st 6 digits 35005. I have a
form for adding new requests which uses a dlookup to display the handst type
as each requst is entered

=DLookUp("[Model]","HSPrefix","[Prefix]='" & Left([ReqIMEI],6) & "'")

Is thereaway to create a link directley between ReqIMEI and Prefix?
 
C

Chris2

storm warden said:
Hi there

I ahev created a database wite two tables whith which there are tow fields i
would litke to create arelationship between

table 1 - requests
Contains IMEI, mobile No. & Name

table 2 handsets

Prefix
Model

I would like to create arelationship between the IMEI and prefix for examble
an IMEI is the 15 digit serial number of a mobile phone e.g. 35005000000000
this is a Nokia 3510. The prefix of this is the 1st 6 digits 35005. I have a
form for adding new requests which uses a dlookup to display the handst type
as each requst is entered

=DLookUp("[Model]","HSPrefix","[Prefix]='" & Left([ReqIMEI],6) & "'")

Is thereaway to create a link directley between ReqIMEI and Prefix?

storm warden,

See my answer on the other post.


Sincerely,

Chris O.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a relationship with a query 1
Relationship 4

Top