Re: Copy Record With VBA (Access 2000)
- From: WCR <WCR@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 13:13:02 -0700
I am an inexperienced database designer, so I am sure my database is not
structured in the most efficient manner. I am trying to keep it simple, just
one table holds most of the information in the database. However, I still
need to figure out a way to use data from one record as the default for
another.
It seems like you know the answer to my question, but think I have other
problems with my approach. Let's say, hypothetically of course, that I had a
table with 10 fields, and I wanted to allow the user the option of creating a
new record with default values for 8 of these fields from an existing record.
How would I do this?
Thanks!
"Tim Ferguson" wrote:
> =?Utf-8?B?V0NS?= <WCR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:5FFFC547-B3B8-40D8-938B-C421EC51EAED@xxxxxxxxxxxxx:
>
> > For example, if you need to create a
> > new record with 50 fields, and 40 of them are the same as an existing
> > record,
> >
> .... then you need a database re-design. Fifty fields is incredible as a
> properly-normalised table: I would guess the remaining ten fields belong in
> this table and the forty should be in half-a-dozen other tables. At least.
>
> That is the point I was trying to get at in the previous post.
>
> All the best
>
>
> Tim F
>
>
.
- Follow-Ups:
- Re: Copy Record With VBA (Access 2000)
- From: Tim Ferguson
- Re: Copy Record With VBA (Access 2000)
- References:
- Copy Record With VBA (Access 2000)
- From: WCR
- Re: Copy Record With VBA (Access 2000)
- From: Tim Ferguson
- Re: Copy Record With VBA (Access 2000)
- From: WCR
- Re: Copy Record With VBA (Access 2000)
- From: Tim Ferguson
- Copy Record With VBA (Access 2000)
- Prev by Date: access 2003 report printer properties
- Next by Date: Dot matrix printer on and/or connected
- Previous by thread: Re: Copy Record With VBA (Access 2000)
- Next by thread: Re: Copy Record With VBA (Access 2000)
- Index(es):
Relevant Pages
|
