Here's the situation: I have about 1,000 records that I want to put into Microsoft Access. Each record is either a substance or an effect and the fields in each record will vary slightly (just think Wikipedia, no two records have the same fields)--some records will have 4 fields, some 8, and so on.
What do you suggest would be the best way to design my database? I would love to use multiple tables, but I don't know if that would make sense.
Any help for this database newbie would be greatly appreciated!
i.e. Can one substance have many effects? Can a substance have no effects?
Can one effect be tied to 0, 1, or many substances?
(Is this a Pharmaceutical database?)
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
For now, assume the two tables weren't related, would it make sense to have 2 unrelated tables (1 for substances, 1 for effects) just so it's easier to enter in data because substances and effects don't share any of the same fields?