1 Topic by identity (edited by identity 2022-06-16 05:50:59)

  • Registered: 2016-01-17
  • Posts: 139

Topic: auto number correction

Hi everyone
I the attached a sample project.
when I enter some children for one person, then in the search form, auto number counts wrong.
in this sample there is one person and 4 children. how can I make the search form only shows one number instead of 4

and there is another problem in the tablegrid. when I record  a new person, all the children from the previous records are also shown in the table grid

please someone help me because I don,t know what is wrong with my project.
thank you

Post's attachments

Attachment icon tabsheets.rar 293.77 kb, 101 downloads since 2022-06-16 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: auto number correction

I don't think you are understanding the principles of relational data.
You shouldn't be holding details of the 'person' and 'the children' in the same table - if you do it that way, there is no way of relating them to each other and, because there is no way of relating them to each other, all the records will show.
Also, I'm not sure what you mean when you write that the 'auto number count is wrong' - that's really not possible as it's just a sequence no' for each line in the tablegrid.
Have a look at the attached and hopefully it will help you to understand the approach you could take (but by no means the only one).
Derek.

Post's attachments

Attachment icon tabsheets3.zip 341.07 kb, 153 downloads since 2022-06-16