Can I combine keys to make another key?

  • Thread starter Thread starter Ron Berns
  • Start date Start date
R

Ron Berns

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.
 
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.
 
Back
Top