RE: 2nd table need to add more fields other than from the 1st tabl
- From: "Curie" <Curie@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Aug 2005 10:58:03 -0700
well, I import a txt file into a table in Access. This is the first table.
Based on information from the first table, and inf. from another table, I
will need to combine both of them and add a couple more fields . This is why
I create the new table. I think I should save data from tables into an array
to manipulate them. Do you know how to do it?
Thanks
"Klatuu" wrote:
> That first thing you need to consider is you are violating a basic database
> normalization rule. You should never store calculated values in a table.
> This is a bad idea for a lot of reasons. On rare occasions, it is reasonable
> to break this rule, but it is so rare, it is not worth considering.
>
> I suggest you rethink your design.
>
> "Curie" wrote:
>
> > I need to add more fields in the second table. This second table is just a
> > copy of the first table but adding more fields (i.e., 1st table have these
> > fields item names, prices and the second table includes item names, prices,
> > subtotals, total).
> > Do you know how to do it programming using VBA's recordset and/or array (MS
> > Access 2000).
> > Thank you,
.
- Follow-Ups:
- References:
- Prev by Date: Re: form question
- Next by Date: Re: Validation Rule
- Previous by thread: RE: 2nd table need to add more fields other than from the 1st table
- Next by thread: RE: 2nd table need to add more fields other than from the 1st tabl
- Index(es):
Relevant Pages
|
