Thanks for the reply, sorry if I have not explained myself very well,
I have a prime table with a field called
location
The location field has a table behind it and users need to select the correct table entry when setting up a master record.
Example: location A
A sub record also needs to be created which is then attached to the master record in order for it to become a live account.
Normally the location will come across from the master record to the sub record by default during the make live process.
As an option users can overwrite the sub record location if required as it may differ in exceptional circumstances.
If however a difference exists I need to pick this up during my validation process.
I therefore need to check master record location against sub record location and if they are different (not often) then I need to generate an error message to bring this to the users attention, just in case they have made a mistake during input.
Both tables link to the same location entries therefore
if the prime table shows location A and the sub table shows location A - no error message.
If however prime table shows location A and the sub table shows location B then I need to generate a message.
I can generate basic if then else statements etc. but I have never tried the above task before.
Sorry this is so long winded, hope it makes sence!!
IP Logged
