I’m trying to create a database to track melanomas. I need to split the excel sheet into a one-to-many relationship because one member can have multiple melanomas.
Tables
memberInfo ß---- one-to-many ------à melenama
meberInfo structure
Name Type Size
id Long Integer4
MRN Long Integer4
Last Text 50
First Text 50
MI Text 50
Sex Text 50
DOB Date/Time 8
Melanoma structure
Name Type Size
melanomaID Long Integer 4
id Long Integer4
MRN Long Integer 4
ProvLast Text 255
Prov FirstText 255
ProvMI Text 255
Degree Text 255
PCP FirstText 255
PCPLast Text 255
PCPClinic Text 255
LastSeen Text2 55
I have multiple excel sheets that I need to import but haven’t been able to figure out how to get these split and yet keep referential integrity.
Any help is appreciated, thanks!
Tables
memberInfo ß---- one-to-many ------à melenama
meberInfo structure
Name Type Size
id Long Integer4
MRN Long Integer4
Last Text 50
First Text 50
MI Text 50
Sex Text 50
DOB Date/Time 8
Melanoma structure
Name Type Size
melanomaID Long Integer 4
id Long Integer4
MRN Long Integer 4
ProvLast Text 255
Prov FirstText 255
ProvMI Text 255
Degree Text 255
PCP FirstText 255
PCPLast Text 255
PCPClinic Text 255
LastSeen Text2 55
I have multiple excel sheets that I need to import but haven’t been able to figure out how to get these split and yet keep referential integrity.
Any help is appreciated, thanks!