Re: Copy Record With VBA (Access 2000)
- From: Tim Ferguson <FergusonTG@xxxxxxxxxxxx>
- Date: Sat, 09 Apr 2005 13:17:44 -0700
=?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: WCR
- 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
- Copy Record With VBA (Access 2000)
- Prev by Date: Re: Initiate a txt Search in Notepad via Access '00
- Next by Date: Re: Initiate a txt Search in Notepad via Access '00
- Previous by thread: Re: Copy Record With VBA (Access 2000)
- Next by thread: Re: Copy Record With VBA (Access 2000)
- Index(es):
Relevant Pages
|
Loading
