Using a Multi-Column Primary Key

View more information about this example

Project/Employee Search Project Select Value 1 Great Project Inventory Super Project Test Project Employees Select Value Alex Antion Alex Groth Alex Knievel Alex Zanuck Alex Zimb Alexander Atkinson Alexander Neville Andrew Scott Arledge Archer Arty Blake Conrad Murphy Dennis Mansfield Eugene Zubler George Pennington George Randall Helen Palmer Ian Gordon Ignace Shaw ipmkkbvr Irina Douglas Ken Price Michael Barrett Michael Koenig Nick Bergman Oleg Douglas Oleg Tim Peter Larsen Serge Richards Stan Simon Vance Cole Victor Tomlin Vitas Reynolds Vlad Young

Projects Project Employees Percent Allocation 1  Alexander Atkinson    1  Ken Price  2  1  Peter Larsen    1  George Pennington    Great Project  Ignace Shaw    Great Project  Andrew Scott    Great Project  Serge Richards    Great Project  Arledge Archer    Great Project  Alex Groth  20  Inventory  Alexander Atkinson    Add New   1 2 of 2

Add/Edit Projects Employees Project Select Value 1 Great Project Inventory Super Project Test Project Employee Select Value Alex Antion Alex Groth Alex Knievel Alex Zanuck Alex Zimb Alexander Atkinson Alexander Neville Andrew Scott Arledge Archer Arty Blake Conrad Murphy Dennis Mansfield Eugene Zubler George Pennington George Randall Helen Palmer Ian Gordon Ignace Shaw ipmkkbvr Irina Douglas Ken Price Michael Barrett Michael Koenig Nick Bergman Oleg Douglas Oleg Tim Peter Larsen Serge Richards Stan Simon Vance Cole Victor Tomlin Vitas Reynolds Vlad Young Percent Allocation

The above example   is available in the following programming languages:
ASP/VBScript, ASP.NET (C# and VB), PHP, Java Servlets, JSP, ColdFusion, Perl.