Solved Help to Split field to new column and multiple rows

[strive4peace]

hi Mahesh,

just one more comment about your data structure ... now that you have code to REPEAT information -- this is a bad idea! Better would be to make a related table with SrNo as a Long Integer and the various lines they have ... maybe also a field to order them. I call this Ordr, since Order is a reserved word, and make it an integer

 

[strive4peace]

ps, Mahesh,

the code could be modified to make the related records

 

[lookforsmt]

Namaste crystal, this is what everyone is following nowadays.
Shukriya Aap Ka, Aap ne Aapka Kimtye Samay Diya (Thank you very much for giving me your precious time)

Coming back to this thread. I am so overwhelmed and dont have enough words to thank you for the knowledge and insight you have shared in dept details.
I will surely make a note of the all links and will try to understand them posted in post #17 to #19 and will make the most of it. Some of the small things one needs to remember while creating table, forms. Didn't realize its importance.

Its an endless Thank you i want to say.

Stay Safe and God Bless.
Dhanyawad Aapko (Thank you)

 

[strive4peace]

you're welcome, Mahesh ~ happy to help