Welcome Guest, Not a member yet? Register   Sign In
Database Update Error-how to handle
#2

[eluser]boltsabre[/eluser]
Sounds like you need to split your data into two tables. Primary keys must be unique, otherwise they are not relational keys anymore!

I'd be guessing from your post you'll need a "system" table (with all the details related to systems), a "process" table with all process details, and a "join" table with three columns:
id - process_id - system_id.
Now you can populate the join table and have multiple "process_id" in there linked to many different "system_id"s.


Messages In This Thread
Database Update Error-how to handle - by El Forum - 07-09-2012, 08:09 AM
Database Update Error-how to handle - by El Forum - 07-09-2012, 09:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB