New and need to learn how to Copy

[firedog]

Hello,

I’m new to access and have done pretty good so far but have run into
problem. I have 4 different tables. Table 1 is the main table that
input information into. I would like Table 2 to be where som
information goes if I click a yes or no button on a form, same fo
Table 3. I would like to make sure that a record is not duplicated whe
I go through Table 1 to look up information and that the record i
copied to only 1 of the two tables so it is not duplicated. Once th
record moves to table 2 or 3 I would like to have a check box option t
move that record to table 4, just to move the record at this point no
to copy it. This sounds very complicated to me since I don’t reall
understand the coding thing, but I think I need some kind of function
or event. In table 1, I have about 5 fields, table 2 and 3 only use
or 4 of those fields. Thank you very much for your help, I didn’t kno
what I was getting into.

J

 

[tina]

i am wondering why you would be moving data from table, to table, to table,
etc. which leads me to wonder if your database tables/relationships are
designed properly. the single biggest mistake Access newbies make is to not
learn the fundamentals of proper table/relationship design; those that
don't, spend a lot of time here in the newsgroups asking how the fix the
many, many problems that result from poor design.
i wouldn't begin to try to answer your question. instead, here's a list of a
few resources you can tap to learn the fundamentals. (bow to Jeff Conrad,
from whose post i nicked the links - nobody does resourse lists like you,
Jeff! <g>)

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
ACC2000: "Understanding Relational Database Design"

Sample Database Models/Table Designs:
http://www.databaseanswers.com/data_models/index.htm

http://www.mvps.org/access/tencommandments.htm

http://www.mvps.org/access/lookupfields.htm
<tina's addition to the list>

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto


i can also recommend the book Database Design for Mere Mortals by Michael J.
Hernandez.

hth