Restrictions on Tables

[emerlita]

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

 

[Guest]

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.

 

[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 -

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.

 

[Guest]

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.

 

[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 -

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