'Next Record' For Another Form

[lhooker]

I have a form (information about parents) that calls another form (information about their children). After entering data on both parent and children forms, I click on a button that executes the 'Next Record' command. The form that has the parent's information clear all textboxes, but he form that has the children's informaton is not cleared. How can I get the same results when the 'Next Record' is executed from the main screen (i.e. parent's information form) ? Both forms use the same table.

 

[boblarson]

Both forms use the same table.

Based on that sentence and the previous info about parent and children information, I can tell that the first thing that needs to happen is you need to fix the table structure. Children should be in a separate table from the parents as parents can have more than one child, children can have more than two parents.

So I think the first thing you need to do is fix that and then we can go on to the forms (which will somewhat take care of them selves since you won't be using the same table for two forms (which also is a major indicator of a potential problem).

 

[lhooker]

Bob,

Thanks for responding ! ! ! I've alloted for six (6) children for each parental record in the table. This application does not need to track every parent of a child. Are you still recommending that the children information be separated based of this information ?

 

[boblarson]

Bob,

Thanks for responding ! ! ! I've alloted for six (6) children for each parental record in the table. This application does not need to track every parent of a child. Are you still recommending that the children information be separated based of this information ?

If your requirements don't require it to include every child of a parent (I just saw a news article from my hometown about a woman with 13 children), nor every parent of a child, then you can probably go about this non-normalized way (unless reporting will need to know how many children there are, how many boys/girls, etc.). Otherwise, yes, you would need to change the way the children/parents are tracked.

 

[ash1123]

After entering data on both parent and children forms, I click on a button that executes the 'Next Record' command. The form that has the parent's information clear all textboxes, but he form that has the children's informaton is not cleared. How can I get the same results when the 'Next Record' is executed from the main screen (i.e. parent's information form) ? Both forms use the same table.

If it is not mandatory to use SINGLE table, then it's better to use with two table.
isn't the concept is same like "Purchasing different product under same invoice?" if so, only then possible for me.