Restrictions on Tables

E

emerlita

Is it possible to do a lot of restrictions in MS Access tables? If it
is, where can i do these restrictions?
 
K

KARL DEWEY

Yes.

What kind of restrictions would you want to do?

If you tell what you want to do then maybe someone can answer the question.
 
E

emerlita

Yes.

What kind of restrictions would you want to do?

If you tell what you want to do then maybe someone can answer the question.

--
KARL DEWEY
Build a little - Test a little





- Show quoted text -
Click to expand...

I have a table called " ICSC Code" with fields IPAddress, Slot
Type(DXM,IPM4, etc), etc..
I want to restrict the IPAddress field unless SlotType = IPM4. If it
is DXM, it should not be allowed to fill it out.
 
K

KARL DEWEY

The actions you describe need to be applied to your data entry form. Test
on data entry of the IPAddress field to see if SlotType field contains
"IPM4" then allow entry. Have it display a message that only "IPM4" is
allowed to enter an IPAddress.
 
E

emerlita

The actions you describe need to be applied to your data entry form. Test
on data entry of the IPAddress field to see if SlotType field contains
"IPM4" then allow entry. Have it display a message that only "IPM4" is
allowed to enter an IPAddress.
--
KARL DEWEY
Build a little - Test a little






- Show quoted text -
Click to expand...

i think that's going to work. thanks a lot :)
 
Top