You need to be more specific with your question. Where are the fields you want to relate to one another (all separate tables?) and what is the common factor which links them? Give an example so forum members can better help you.
THANK YOU FOR REPLY,THE FOLWOING EXAMPLE MAY BE HELP :
For PP1VALUE 1VALUE 2VALUE 3X1777888999X2555444777X3222666555BLUE COLOR VALUES TO BE ADDEDGREEN COLOR CONSTATNT FEILEDFor PP2VALUE 1VALUE 2VALUE 3X51114556435456X633316245X7666415441BLUE COLOR VALUES TO BE ADDEDGREEN COLOR CONSTATNT FEILEDFor PP3VALUE 1VALUE 2VALUE 3X85646551X95454236145X105615322558BLUE COLOR VALUES TO BE ADDEDGREEN COLOR CONSTATNT FEILED
SO PLEASE HELP US.
THANKS...
If nothing else becuase that still makes things clear as mud,
calling your tables things like PP1 and your columns x1 will make your system impossible to navigate not just for anyone else but, after a day or two, for you as well.
So how do you want to relate these fields? If you give an example of your data in context, then describe what you need to achieve, we might be able to help. I simply don't understand what you want to do! :-(