Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mjgwagner

    Searching portal records

    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.
  2. mjgwagner

    Searching portal records

    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...
  3. mjgwagner

    Searching portal records

    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...
  4. mjgwagner

    Searching portal records

    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...
  5. mjgwagner

    Searching portal records

    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...

Part and Inventory Search

Back
Top