Create table with field names based on the value of a field in another table.
Hi Jeff
I will try to explain my problem with an example:
I have a table A and a table B in Microsoft Access 2003.
In table A I would like to store Benchmark ID's (e. g.
Benchmark Name 1, Benchmark Name 2, etc.). I have
designed a form where the end users can enter additional
Benchmark Names (ID's).
In table B I would like to store procentages per
Benchmark (colum titel) and Portfolio (row titel). For
this screen I will design a form as well (or may include
it in the frist on).
Summary
=======
The user should be able to add a Benchmark ID (witch
should be added on table A) and enter a procentage for
the new Benchmark to the current and new Portfolios
(table B).
If you have any further questions please feel free to
contact me.
Regards
Simon
-----Original Message-----
Simon
While an Excel spreadsheet can only use multiple columns
to show "types", it
is not considered good relational design to build tables
whose fieldnames
are "types of" something, or are "repeating values" (for
example, "January",
"February", ... -- these are repeating monthnames).
Could you describe your underlying business need?
Perhaps the 'group's
readers could offer a different approach than the one
you've decided you
need...
--
Good luck
Jeff Boyce
Access MVP
.
|