maximum no. of fields?
- Thread starter amanco
- Start date
Mile-O-Phile said:
i have 60 fields in this table ... i was wondering about the limit. i'm constructing family history, where each person can have <=10x-Sisters, <=10-brothers, =<4x-Spouses, =<10-Sons, =<10daughters + parents and grandparents maternal and paternal.
thats where the high number, it's not complicated though
Mile-O-Phile said:
I read the the posts related to genealogy, very informative and nice. however their approach is different than mine. they are tracking the families while i am investigating the genes of a particular patient.
what that means is when the patient comes he could have many relatives (1-to-many) given by my table which i could have splited more to parents/grand parents/siblings/so on ... but it doesnt make a big difference, i think i see it more tidy for one table. the reason for that is this table is going to be related to another table where i am going to inquire about each of these relatives hunting for related affected genes. it's a one time entry for each patient where he/she has many relatives and those relatives could have diseases.
if you have further suggestions or comments please let me know, because i really benefited from reading the genealogy posts. and not to forget you are the man
Similar threads
