Look I am not sure exactly what you are trying to accomplish but it sounds like your trying to put a band-aid on a bullet wound or the cart in front of the horse. If you are trying to build a relational database and capitalize on its strengths than you need to design a true relational database. Then its a simple matter of just designing a query to get the data you need. However without that solid relational database foundation designing a query to work the way you want it is going to be a nightmare. Now I'd like to help with your question but I don't do hatchet work and I would never advise anyone to do so either --- as it will inevitably come back and haunt you later. I have asked what relationships you have set up in the database so I can help you design the query you want to use but your answer seemed to be you do not have any relationships (or at least you are not aware of any) --- and instead you seem to have a single index (roll number) that you put in each table so you can try and poll your data that way... and again I will state doing that is the same thing as putting all that data in one big table. So... What data (of the data you have) do you need to display on this page?? What data (of the data you have) will you need to edit on this page?? If all of it... are there any smaller logical units than the whole thing that you could allow them to work on and if so how would those smaller units be related? I don't know how what your database looks like and I don't know how it all meshes together so unless you can supply some kind of data model for you database I can't help you other than the advise I have already given you. P.S. To answer your question directly and in this case hypothetically. Yes you can set up relationships between tables without putting the same single key index into every table but that requires you figuring what those relationships should be and then setting those relationships up. They do not spring to life on their own. THEN... depending on what those relationships are and how they relate to each other and to the data value "Roll Number" one can easily design a query (or several queries) to retrieve the View that you want displayed.
--- On Tue, 2/17/09, Kalyani Tirumala <[email protected]> wrote: > without given roll no in every table can i give relationship to all tables. > when i design form in MS-Frontpage based on Roll No i need to get the > results from database. that is the reason i have taken roll no in every > table. [Non-text portions of this message have been removed]
