tet3828 Posted February 12, 2008 Share Posted February 12, 2008 Here is the table I have set up. If anyone has a better approach please help. |Key Value|Date|License Number|Radition Saftey Officers|Physicists| obviously there will only be one key value and one date one license number per license. HOWEVER multiple radition saftey officers and phyisicist can be placed on one license. easy enough. my GUI will have check boxes with each doctors / physicists name on it so the can be added to the license as needed. do I add these values as a continious string? how can I edit those values in the future if I have 20 first and last names in a record? Quote Link to comment Share on other sites More sharing options...
toplay Posted February 12, 2008 Share Posted February 12, 2008 You would want to create another table that holds just officers, and maybe even another to hold physcicists. Read up on data normalization before you implement anything. http://www.datamodel.org/NormalizationRules.html http://www.google.com/search?hl=en&q=db+normalization Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.