priest Ivan Delic (8/13/2012)
Hi!I forgot one thing. In paper-data there is about 30 books with 100 pages in each of them. On each page there is 10 records, so 1,000 records per book, equally about 30,000 records all.
In app that was given to me, I have assignment to print only one record on printing form (which is called in Serbia Baptism paper, I don't know in English how to call it). So I need to print one record on one page with all data for that record (book, page, number, dates, name, parents, priest, godfather, about 15 fields). As for ID field, it is PK, Auto-increment and not changeable in app.
Sincerely yours,
Fr. Ivan
Serbia
I make a small observation.....it would appear from what you have said that that the printing app requires you to provide the order of book/page/number etc prior to print....by linking to the RECORDS table on ID ...it seems you only have one method of sort order?
what are you going to do if, for instance you decide to change your mind and print 5 records per page, book - place of baptism - chronological order of dob?
I am not sure that the code will give that you a degree of flexibility going forward...but thats for you to decide.
...or of course, I may have misunderstood 🙂
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day