G
Guest
pls help me,
i have a form which require user to input all the user information,
then in the form there is a subform which require the user to input their
required server information
while i have two table also,
one is used for storing user information
and the other is used to store the server information
as one user may require 10 server,
so both server and userinformation have a field which is "staff no"
the case now is that,
when a user Peter require one server(such as sp01) and type the information,
(at this moment i have one record which is peter want sp01 of record no.0001)
then maybe after a few day or a few min later,
Peter want to require one more server,
so he type the information again,
but when he fill the form of Server information,
he just input the server that he is going to have (such as sp02)
then now i have four record ~~
which is
record no 0001 peter want sp01
record no 0001 peter want sp02
record no 0002 peter want sp01
record no 0002 peter want sp02
the record no is a autonumber,
what can i do to prevent the repeated record???
I want the final result is
record no 0001 peter want sp01
record no 0002 peter want sp02
i have a form which require user to input all the user information,
then in the form there is a subform which require the user to input their
required server information
while i have two table also,
one is used for storing user information
and the other is used to store the server information
as one user may require 10 server,
so both server and userinformation have a field which is "staff no"
the case now is that,
when a user Peter require one server(such as sp01) and type the information,
(at this moment i have one record which is peter want sp01 of record no.0001)
then maybe after a few day or a few min later,
Peter want to require one more server,
so he type the information again,
but when he fill the form of Server information,
he just input the server that he is going to have (such as sp02)
then now i have four record ~~
which is
record no 0001 peter want sp01
record no 0001 peter want sp02
record no 0002 peter want sp01
record no 0002 peter want sp02
the record no is a autonumber,
what can i do to prevent the repeated record???
I want the final result is
record no 0001 peter want sp01
record no 0002 peter want sp02