G
Guest
Hi Steve
I decided to start from scratch due to something a work colleague told me.
Which was sometimes a form or macro can become corrupted for no reason and
when this happens you have to start again by deleting the macro and the form
and starting again. I did this and it seems he was right because now
everything works fine with no problems so I am now sorted. on that front. So
thanks for your help, I probably did not explain the problems to you the way
I should have done and probably caused a few headaches for you. But thank
for trying anyway.
The only problem I have now is trying to find a way round the fact that
within my database I have duplicate information ie. parent 1 is asked do you
smoke, do you want to give up, are you employed, if yes is it full time or
part time etc. parent 2 is asked the same thing. If I have this on one
table its a lot of information so I would like to separate them how is this
best done. Bear in mind I already have the children separated from the
parents in a separate table with the link to the parents membership ID for
ie. parent 1 could = member number 1 with the child number as 1/1 for first
child and 1/2 for second child etc. how could I then connect the second
parents link within Member ID can I use the same member ID number would this
clash. I am not sure how best to set this up. Would appreciate your help.
If I can split this table down into small managable tables it helps.
Wendy
I decided to start from scratch due to something a work colleague told me.
Which was sometimes a form or macro can become corrupted for no reason and
when this happens you have to start again by deleting the macro and the form
and starting again. I did this and it seems he was right because now
everything works fine with no problems so I am now sorted. on that front. So
thanks for your help, I probably did not explain the problems to you the way
I should have done and probably caused a few headaches for you. But thank
for trying anyway.
The only problem I have now is trying to find a way round the fact that
within my database I have duplicate information ie. parent 1 is asked do you
smoke, do you want to give up, are you employed, if yes is it full time or
part time etc. parent 2 is asked the same thing. If I have this on one
table its a lot of information so I would like to separate them how is this
best done. Bear in mind I already have the children separated from the
parents in a separate table with the link to the parents membership ID for
ie. parent 1 could = member number 1 with the child number as 1/1 for first
child and 1/2 for second child etc. how could I then connect the second
parents link within Member ID can I use the same member ID number would this
clash. I am not sure how best to set this up. Would appreciate your help.
If I can split this table down into small managable tables it helps.
Wendy