ms access problem

[abu taher]

I make two table in ms access. both of two table has like 'student name' column. when I enter a name it save in table1. Now I want this name will save in table2 automatically. I mean I don't enter this name in table2, but it will store this name automatically when the name enter in table1.

[JP Romano]

Hi... I'm pretty new to all this, so forgive my ignorance, but wouldn't it be easier to have one field "name" in one table, then use that field in your queries, forms, reports, etc?
Is it necessary to have the same data in seperate tables, then copy / link the fields?

- Not questioning your design - like I said, I'm new to this myself.

[debasisdas]

do you want to do all that from VB 6.0 ?

[abu taher]

if possible then please tell me how I do it.

[vtelebyteM]

first clear your side......
your question is difficult to understand.....
make it more brief.....

[debasisdas]

What i understand from your post is each transaction that is executed on table1 needs to be reflected in table2.

what you need to do is execute the same sql from frontend on table2 as table1.

if using using oracle taht can be simply done by puttin all the DML statement into a block of code in a procedure.

[abu taher]

you can tell me with vb6.

[QVeen72]

Hi,

Normalise your database, No need to save same data at 2 places, as you may later face syncronization problem, and Redundant data problem.
What you need to do is Create a StudentMaster Table With ID, Name, Address.. etc.. and Save Stud_ID, in other Linked Tables,
To get the name, Link it with master table..

Regards
Veena

[abu taher]

How can I link?

[javmedia]

Search the web for effictive and simple examples of

"SQL cross join"

and

"Jet4.0 connection strings"
&
"MS ADO DNSLess connections"

to apply VB6/VB5 to work with MS Access effectively