I have three tables.
1st table is colors (01=Red, 02=Yellow, etc.)
2nd table is sizes (01=small, 02=medium, etc.)
3rd table is shapes (01=square, 02=circle, etc.)
Is it possible to create a master table with the key equal to the
combined selections of each of the other tables. For example, 010101
is a red small square, 010202 is a red medium circle.
Thanks.
Jeff Boyce - 06 Jan 2005 02:31 GMT
Ron
Open a "master" table in design mode. Include the fields you wish to have a
combined key over.
Click on the <Index> button (or chose the menu item). Enter a name for the
combined index in the first column. In the second column, first row,
select/enter the first field. Without adding a new name in the first
column, select/enter the second field in the second row of the second
column.
Now add a third field in the third row of the second column.
Check the bottom of this window to set the properties.

Signature
Good luck
Jeff Boyce
<Access MVP>
> I have three tables.
> 1st table is colors (01=Red, 02=Yellow, etc.)
[quoted text clipped - 6 lines]
>
> Thanks.