Related data, please help!

[Suzi]

Hi, I am trying to get my access form to, for example, if
I enter a job number of DSXXX in one field, to
automatically know that that job number relates only to
the Bournemouth store and to enter BOURNEMOUTH in another
field. How do I do this?!

 

[Ivar Svendsen]

Hello.

Set the ControlSource property of the second field to
something like:

=DLookup("STORE"; "STORETABLE"; "JOBID='" & m_JOBID & "'")

"STORETABLE" is the name of the table from which to get
the information.

"STORE" is the name of the field containing the store name.

JOBID is the name of the field containing job number.

("STORE" and JOBID will be fields in the table STORETABLE).

m_JOBID is the name of the unbound form field where you
enter the job number to search for.



Regards,
Ivar Svendsen