Re: To add a new record by copying from another record then change the primary key

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 16:08:55 -0500

You should consider storing the information that is common to a Company,
regardless of Division, in a different table, then using a query to pull it
all together when you need it.

tblCompany
CompanyName (PrimaryKey)
---Other fields related specifically to a company

tblCompanyDivisions (the two fields are a composite primary key)
Division
CompanyName 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"SF" <suefong.shen@questpharm.com> wrote in message
news:u3URkOlfEHA.636@TK2MSFTNGP12.phx.gbl...
> Hi, Lynn,
>
> The primary key is a combination of two fields, for instance Company Name
> and Company Division. When adding records with the same Company Name
> (CompanyA, DivisionA) but different Division (CompanyA, DivisionB), most
of
> the fields in these two records are the same and I want to save user some
> time to enter the same data.
>
> How to do it?
> "Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message
> news:OjnsNjkfEHA.1644@tk2msftngp13.phx.gbl...
> > Why are you wanting to store redundant data? One of the reasons for
having
> a
> > relational database is to avoid redundant data.
> >
> > -- 
> > Lynn Trapp
> > MS Access MVP
> > www.ltcomputerdesigns.com
> > Access Security: www.ltcomputerdesigns.com/Security.htm
> >
> >
> > "SF" <suefong.shen@questpharm.com> wrote in message
> > news:u1offfkfEHA.1644@tk2msftngp13.phx.gbl...
> > > I use the form to add new records, but I want to copy most of the
fields
> > > from another record and just change the primary key to create this new
> > > record.
> > >
> > > I'm able to bring up the record that I want to copy from. What shall I
> do
> > > after I change the primary key field?
> > >
> > >
> >
> >
>
>

Relevant Pages