A
Aproblem
I have three tables:table modem A table modem B and table equipment.
I will have to insert serial numbers of the modems in the three tables. The
serial numbers will be different in table A and B.
Note the equipment table is only there to input all the serial numbers of
the modems those found at somebody's place and those found in the store.I
need this table equipment to relate to my whole database including the table
A and TableB.
Therefore i inserted the field serial numbers in my tables and linked the
three tables.
Now suppose i insert the serial number 'wer28740' in table A i do not want
to be allowed to insert this value i.e'wer28740' in table B. I want a message
to pop and tell me that this is not allowed.
I am not a programmer and therefore i do not know what to insert in the code.
i have tried to make the matter simple and hope that you will be able to
help me because i have asked many people and they told me to do such and such
thing which did not work.
I will have to insert serial numbers of the modems in the three tables. The
serial numbers will be different in table A and B.
Note the equipment table is only there to input all the serial numbers of
the modems those found at somebody's place and those found in the store.I
need this table equipment to relate to my whole database including the table
A and TableB.
Therefore i inserted the field serial numbers in my tables and linked the
three tables.
Now suppose i insert the serial number 'wer28740' in table A i do not want
to be allowed to insert this value i.e'wer28740' in table B. I want a message
to pop and tell me that this is not allowed.
I am not a programmer and therefore i do not know what to insert in the code.
i have tried to make the matter simple and hope that you will be able to
help me because i have asked many people and they told me to do such and such
thing which did not work.