Autoupdate corresponding row data in other columns of Second table

[bctra]

I have 2 Table . Table1 is Excel imported date having field "Name" "School" "Roll No" . In table 2 having field "Sl.No" "Name" "School" "Roll No" "Other Information". I want that If in Table2 ,I select the Name from Lookup Column of table 2 Data the "School" , "Roll No" automatic get updated accordingly. Please help me

[NeoPa]

From what you say it seems like you need to run an update query on your two tables at a time appropriate to your situation. There is really very little helpful information in your question so it's hard to help much, but the fundamentals are there so get to it and let us know how you get on.

If you need more help then you'll need to provide us with a question that makes better sense.

[bctra]

I am trying to makeunderstand with an example. I am having a date table with column "First_Name" "Middle_name" and "Last_Name". I want to make another table where there will be column "First_name" , "Middle_Name" " Last_name" and some additional field. I will choose the New tables "First_name" column as a lookup wiziard and take the date from Table1 " First_name". What is the procedure that in the new table the "Middle_name" "Last_name" can take date from Table1 while choosing the first name from drop down

[zmbd]

bctra:
I don't intend to sound mean in anyway; however, neither your first or second posts are very clear. However, from what I can gather you really need to visit the these two links:

Start with: A Tutorial for Access

Then from what you describe your database is in serious need of normalization: Database Normalization and Table Structures. as it is never a good idea to store the same information in two or more tables.

[bctra]

Please find below two images which may help you to understand

[zmbd]

Neither image comes thru.

In general images from outside sites wouldn't be available to me or many of the other mods when using business computers as the I.T. Firewalls tend to be set to block them. Therefore, it is always preferable to try and provide the details within the post.

Nor do I accept emails for attached files... please no offense intended, this is simply "good computing practice."

I you will click on the advanced button, you will be taken to an editor where you can then attach the images to your post.

[NeoPa]

Making better sense doesn't mean posting another explanation with no punctuation and sometimes without even spaces between words. That is just careless in any language. Nor does it mean simply posting unexplained pictures (even if the links posted actually worked, which I'm guessing you didn't check before submitting).

If you want assistance then please have the basic courtesy to explain your problem as clearly as you can in a properly formatted post. Nothing you have posted so far even matches the bare minimum of information required by the site rules and needed by those that would want to help you just to be able to understand well enough what you want. I'm sure you can appreciate that without knowing what you want it will be difficult to help you find a solution.

[bctra]

Dear Sir ,I am sorry for that:

Let me explain with an example:
I am having existing data table

(Say T1) having records in three fields First_Name , Middle_Name and Last_ Name. I want to create another table

(Say T2) where fields will be F_Name , M_Name ,L_Name , Address , PIN , Phone_no and Remarks.

What I want is , if in table T2 I use F_Name field as a lookup wizard linking to T1's First_Name , field M_Name and L_Name should take the data from T1's Middle_Name and Last_Name respectively.

Please help me.

[zmbd]

It appears that you are trying to use a look-up field at the table level - yes?

Unless you are going to publish the database to Sharepoint or using the webcomponets I highly advise against doing so at the table level. Instead, do this at the query level or at the form level. Why? The Evils of Lookup Fields in Tables

One can make arguments for using them at the table level; however, when I discovered and starting using these at the table level I ran into a ton of issues trying to write my queries and so forth. Then I found the above link, and went back and removed these.

SO:
1) Confrim or correct that you are using table level lookups

2) Post your SQL you are using for your record source (formated using the <CODE/> button in the toolbar) We'll take a look at it and see what is going on. The SQL can still be used at the query level

3) Your database appears to not to follow the rules for normalization. Please see my post#4 and follow those two links.

[NeoPa]

Now Z has reformatted your post it starts to make a little more sense (Thanks to Z for that). It is still missing a great deal but let's see if we can make a stab at guessing what you actually want and then give what advice we can in such circumstances.

Putting bits together from the various different posts (You left some of the important details out of your latest post so we have to switch between all the half-explained posts to have an idea of what you're talking about.), it seems that you need to update the data from one table from the temporary data in an imported table. As it's imported one assumes it is not always available so the data in the main table needs to be updated rather than simply running a query linking the two tables together.

As it happens, the answer that fits this question is already in post #2. That is what you need to do in very basic terms. Nothing more precise or helpful can be given at this stage as, for that, we'd need more information from you. That was all made clear in post #2 too.

So far there has been no further helpful information from you, but only the same information reposted in very poor format every time. We cannot help you if you don't provide a sensible question or any information that tells us what you need.

[bctra]

Please find the image , what I want in my database.

[IMG]

[/IMG]

http://postimage.org/image/sldv7n2fv/

[NeoPa]

If I'm really still not getting my meaning through to you after all that, then I suspect it's time to give up. If you believe posting a single picture equates to an explanation of what you should be asking for, then you are going to struggle with much more in life than simply database work.

I'm happy to admit I was shocked to see what you'd posted - and I don't shock very easily.