importing data from another table

[callumsalfield]

Hi im setting up an access 2000 DB. I have two tables Schools and
Visits, the schools table contains information on the school name and
primary(yes/no) secondary(yes/no) headteacher(text). The visits table
has a drop down list with the names of schools in it (dynamically
generated from a query on the schools table). How can I make access
fill in the three fields,primary(yes/no) secondary(yes/no)
headteacher(text), from the data on the record from the school in the
schools table into my visits table? Any help appreciated or if
clarification of question need i will try.... Cheers

 

[Ken Snell \(MVP\)]

Perhaps this article will assist:
http://www.mvps.org/access/forms/frm0058.htm

You will have to use a form to do what you seek. You cannot do it directly
in a table (note that it's not a good idea to ever do data entry directly
into a table -- tables should not be exposed to users). Also, if the data
already exist in one of the tables, it's probably not a good idea in this
case to redundantly store the data again in another table -- you can always
use a query to look up the data you seek.

 

[callumsalfield]

I do have forms set up for the input, but the people who i work for
generally look at the forms (filled in) and the table view wehen using
the data although they do use querys occassionally. They like to be
able to look at one event and have all the information there already
the change im implementing with the second (schools) table will just
cut down on data input time.... I will look at the article thankyou.

 

[Joseph Meehan]

Hi im setting up an access 2000 DB. I have two tables Schools and
Visits, the schools table contains information on the school name and
primary(yes/no) secondary(yes/no) headteacher(text). The visits table
has a drop down list with the names of schools in it (dynamically
generated from a query on the schools table).

How can I make access
fill in the three fields,primary(yes/no) secondary(yes/no)
headteacher(text), from the data on the record from the school in the
schools table into my visits table?

Normally you would not. You normally do not copy data from a related
table to a second table, you use the relationship to let access use the
information from the School table.

I don't know your data and how it works, but the exception would
normally include the situation where that data may change in the future and
your DON'T want it to change in the visits table. Most of the time you
would want the data to be updated to the visits table if it changed in the
school table.

Using links to allow the tables to share data, usually saves space, and
efficiency as well as eliminating the update problem.

 

[callumsalfield]

Normally you would not. You normally do not copy data from a related

table to a second table, you use the relationship to let access use the
information from the School table.

I don't know your data and how it works, but the exception would
normally include the situation where that data may change in the future and
your DON'T want it to change in the visits table. Most of the time you
would want the data to be updated to the visits table if it changed in the
school table.

Using links to allow the tables to share data, usually saves space, and
efficiency as well as eliminating the update problem.

I dont want the data to change when in the visits table because this is
a record of events that have happened so we want for example the
headteacher at the time the event happened not the one now!