F
fran
Hi
I want to enter a new record into a table. the table1 is
related to a table 2 by IDNumbers. In this form (inputting
records to table1) I would like to input only new
IdNumbers and have the IDNumber added to Table2. ie If
the IDNumber already exists in Table 2 there should be a
message saying "this IDNumber is not new, Please choose a
New ID Number". Then when a new number is keyed in there
should be message saying "IDwhatever is a new IDNumber Do
you wish to add this?" Then the new idnumber is added to
Table2 and input into table 1 can proceed. Thanks
Fran
I want to enter a new record into a table. the table1 is
related to a table 2 by IDNumbers. In this form (inputting
records to table1) I would like to input only new
IdNumbers and have the IDNumber added to Table2. ie If
the IDNumber already exists in Table 2 there should be a
message saying "this IDNumber is not new, Please choose a
New ID Number". Then when a new number is keyed in there
should be message saying "IDwhatever is a new IDNumber Do
you wish to add this?" Then the new idnumber is added to
Table2 and input into table 1 can proceed. Thanks
Fran