amend help

[tina]

Hi
My users have a table with many fields and used in a variety of querys
reports another user wants most of this data plus wants to add extra fields
..how do I set up second table so information is updated from first table
without losing new information for each record
simple example
table 1
code supplier manufacturer switch off date
yaa0000 d0001 b0001 5/5/05
yaa0000 e0001 b0001
table 2
code supplier manufacturer switch off date questionaire result
yaa0000 d0001 b0001 85
table 1 had switch off date added and new record added with new supplier
I can append new record but do not no how to amend date field in first record
Any Ideas where to start
Thanks
Tina

 

[Lynn Trapp]

Don't create a second table. Merely add the [QuestionaireResult] field to
the first table and give your users access only to what they need via
queries.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[tina]

I must of been half asleep when asked this as it is pretty obvious what I
need to do that is create a query using data from both tables then create new
table and delete second table rename new table as second table
Sorry if I wasted anybody's time
Tina

 

[Lynn Trapp]

I must of been half asleep when asked this as it is pretty obvious what I

need to do that is create a query using data from both tables then create
new
table and delete second table rename new table as second table
Sorry if I wasted anybody's time

It's not a problem. We are all "half asleep" from time to time and need
someone to poke us in the ribs. <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html