A
Angeliqur
oke, let me explain a bit more
i have the next table
partsID discripsion (text field) orderparts (number field) supplaer
and more....
1 Cilinder 05120100
Schreinemacher ...........
2 Cilinder 05120101
Schreinemacher ...........
2 Valve 02156412
Schreinemacher ...........
etc...
now what i want is that when i fill in a new record de field orderparts
will be checkt at dubbel entry by access. On a form is this the first field
that
i have to fill in, now if the nummer exists i want a messege or something
this must then be dun after a update i think
I want this so that i do not type in the same orderpart in my table
also i want to make in a quary a field whare i join the fields "discrpsion"
and "orderparts" together
can i do this?
many thanks in advance
Angelique
i have the next table
partsID discripsion (text field) orderparts (number field) supplaer
and more....
1 Cilinder 05120100
Schreinemacher ...........
2 Cilinder 05120101
Schreinemacher ...........
2 Valve 02156412
Schreinemacher ...........
etc...
now what i want is that when i fill in a new record de field orderparts
will be checkt at dubbel entry by access. On a form is this the first field
that
i have to fill in, now if the nummer exists i want a messege or something
this must then be dun after a update i think
I want this so that i do not type in the same orderpart in my table
also i want to make in a quary a field whare i join the fields "discrpsion"
and "orderparts" together
can i do this?
many thanks in advance
Angelique