Creating a relationship with a query

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...

storm warden,

In Table requests, break the IMEI field into a 6-digit prefix field
and a 9-digit suffix field, where both fields are the Primary Key.

In Table handsets, use the Relationship's window to link
requests.Prefix and handsets.prefix.


Sincerely,

Chris O.
 
Back
Top