data determines which table to use

  • Thread starter Thread starter Ricoy-Chicago
  • Start date Start date
R

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
 
Try this ---
IIF([extension code] = "000", [table 2].[description], [table
1].[description])
 
Thank you!
KARL DEWEY said:
Try this ---
IIF([extension code] = "000", [table 2].[description], [table
1].[description])
--
KARL DEWEY
Build a little - Test a little


Ricoy-Chicago said:
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
Click to expand...
Click to expand...
 
Back
Top