Hi!
Basically I'm creating a database in which i have 2 fields called "Product Code" and "Product Name" respectively in one table each with a number of entries.
What i require is that in the form if someone choses a particular Product Name the corresponding Poduct Code should appear on its own and if someone choses a particular Product Code its corresponding Product Name should appear on its own. I'm able to create a one way relationship but I have no idea how to create a 2 way. basically if any one of them is selected the corresponding value of the other one from the Products table should appear on its own. I hope you understand my problem!
Please help.. No idea what to do!!!!
thanks