Journal table

32 views
Skip to first unread message

Heather McHenry

unread,
Jun 13, 2013, 11:35:54 AM6/13/13
to erme...@googlegroups.com
I noticed that the 'journal' table is included in the list of tables, but I can't seem to figure out where it links to, if anywhere.  Is it an orphan table?
 
Heather

____________________________________

Heather McHenry

Acquisitions Librarian

Roger Williams University School of Law

10 Metacom Avenue

Bristol, RI  02809

P: 401.254.4537

F: 401.254.4543

W: http://law.rwu.edu/library

Sally Smith

unread,
Jun 21, 2013, 3:12:48 PM6/21/13
to erme...@googlegroups.com
Hi Heather,
Did you received any replies to your inquiry about the journal table?

The journal table is linked to the database table.  I have added several fields to this table, vendor, platform, fund code, notes, fiscal year, url, start date, perpetual access etc. and linked it to the problem form. I use it to track my print+online titles and individual e-journals


Sally


Sally Smith                
Bethel University Library/Serials Dept.    
3900 Bethel Drive  St. Paul, MN 55112
Phone:  651-635-8544   Fax:  651-635-1979
http://library.bethel.edu


--
You received this message because you are subscribed to the Google Groups "ERMes" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ermeserm+u...@googlegroups.com.
To post to this group, send email to erme...@googlegroups.com.
Visit this group at http://groups.google.com/group/ermeserm?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

Heather McHenry

unread,
Jun 21, 2013, 3:16:50 PM6/21/13
to ERMes Group
Sally
 
I did receive a reply that the table is liked to the Database_Name field in the Database table.  I'm thinking of using that table for tracking the individual titles and I'm wondering where the best place to put it on the form.  I was thinking of adding another tab on the "All Database Information" form. 
 
Heather


Sally Smith

unread,
Jun 21, 2013, 3:28:51 PM6/21/13
to erme...@googlegroups.com
Heather,
I created a Journal Form, since I had so many elements I wanted to incorporate.  I included fields from the problem form and this has worked well for me.  See attached.

Sally


Sally Smith                
Bethel University Library/Serials Dept.    
3900 Bethel Drive  St. Paul, MN 55112
Phone:  651-635-8544   Fax:  651-635-1979
http://library.bethel.edu


Journal form.JPG
Reply all
Reply to author
Forward
0 new messages