I've got the report working somewhat. I set the calculated field in the parent file to be stored. The challenge at the moment is to determine why some of the records aren't getting pulled.
The call number is the key field although it's a pain being a calculation on one side. The Topic could be Santa Fe Railroad, the sub topic could be container trains and the sequence number is simply the sequence of when the book or video was obtained (004 is the forth item procured in the...
I had experimented with that approach initially and I'll look into it again but if my memory serves me correctly the challenge I ran into was that the call number in the child table is a stored string but in the parent table it's a calculation so that was giving me trouble extracting the book...
The parent file contains all the specifics of the book or video (name, author, copy right, etc.) One of the items it has is what's called a call number made of of a topic category, sub topic category and a sequence number. The child also contains this call number as well as the fields for the...
I've got a library database and I have a sub-table where I store checkout data. I need to be able to search the sub-table for those items that are checked out. I'm having trouble moving through the sub-table records. I can find the first occurrence of the related record but not any of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.