I have a table that has 13 fields. Of those 13 fields, four fields will be used in all of the records. The remaining 9 fields will only be used in about 50% of the records.
In this case, do I break the table up into two tables, a Parent and Child with a one:one relationship?
If I do make two tables, how do I force a one to one relationship and prevent multiple child records from being created?
Or do I just two different input forms to fill in the table?
__._,_.___
Posted by: david.pratt@outlook.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar