data determines which table to use

[Ricoy-Chicago]

Access XP.
I have a table that has the fields "Extension code" and "Description" and
I have a form where an "Extension code" is going to be entered following
this criteria:
(a) If the extension code is known it will be entered by the user and the
field "Description" is filled by the form
(b) If the extension code is unknown a 000 will be entered by the user and
the "Description" is filled by the user

My problem is that the "extension code" 000 has a relationship of
one-to-many while the rest of the extension codes are a one-to-one.

What I want to do is:
IF "extension code" <> enter "description" from table 1
if "extension code" = 000 select "description" from table 2
Is this possible?
Do you need more info.?
Thanks

 

[KARL DEWEY]

Try this ---
IIF([extension code] = "000", [table 2].[description], [table
1].[description])

 

[Ricoy-Chicago]

Thank you!

Try this ---
IIF([extension code] = "000", [table 2].[description], [table
1].[description])
--
KARL DEWEY
Build a little - Test a little

Access XP.
I have a table that has the fields "Extension code" and "Description" and
I have a form where an "Extension code" is going to be entered following
this criteria:
(a) If the extension code is known it will be entered by the user and the
field "Description" is filled by the form
(b) If the extension code is unknown a 000 will be entered by the user and
the "Description" is filled by the user

My problem is that the "extension code" 000 has a relationship of
one-to-many while the rest of the extension codes are a one-to-one.

What I want to do is:
IF "extension code" <> enter "description" from table 1
if "extension code" = 000 select "description" from table 2
Is this possible?
Do you need more info.?
Thanks