Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2005

Tip: Looking for answers? Try searching our database.

Can I combine keys to make another key?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ron Berns - 05 Jan 2005 22:59 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.