Is there any way to setup a make-table query so that it names the
fields of the new table based on values in a different table.
For example, I have the following fields: Noun, Adjective, Modi 1 Name,
Mod 2 Name, Mod 1 Val, and Mod 2 Val. Listed under these fields are
the records of the table and the value of each field.
Noun | Adjective | Mod 1 Name | Mod 2 Name|Mod 1 Val|Mod 2 Val|
-------|------------|------------|-----------|---------|---------|
<name> |<adjective> | Value | Power | 255 | 65W |
<name2>|<adjective2>| Tolerance | Package | 5% | 0603 |
-------|------------|------------|-----------|---------|---------|
Is there a way to use a make-table query to make a new table that
automatically names the fields based on a value in a table?
The new tables made from a make-table query:
New Table 1:
Noun | Adjective | Value | Power |
-------|--------------|--------|-------|
<name> | <adjective> | 255 | 65W |
----------------------------------------
New Table 2:
Noun | Adjective | Tolerance | Package |
-------|--------------|-----------|---------|
<name> | <adjective> | 5% | 0603 |
---------------------------------------------