Yes, table relationships can be a challenge. But they are needed for speed and database size reasons. The tradeoff is as your system grows its performance will degrade.
We already collect userID, product code, shift information and many other items of information along with the sample. From there you can specify any other user defined information that you also want store along with the sample.
You can also add columns to our database tables. The only restriction is that they must accept null values.
Our table structure for the SPC module is straight forward and I’m happy to show you the layout but it is beyond what can be done over the forum. Feel free to call in and ask for Tom.