What it needs to do: Search by: title, ISSN, serch results: title, date, issure number, vol. number, supplements, recieved? Show items not received yet Autogenerate the next year's entries ERD: +-------------+ | Frequency | |-------------| | id | | frequency | +-------------+ | | /|\ +--------------------+ +------------------+ | Journal | | Issue | |--------------------| |------------------| | id | | id | | issn | /| journal | | title |---------------| date | | frequency | \| arrival_date | | subject | | issue | | publisher | | volume | | vendor | | supplements | | cost | | status(boolean)| | bought | +------------------+ | renewed | | subscription_ends| | cancellable | | notes | +--------------------+ \|/ \|/ | | | | +-----------------------+ +--------------------+ | Publisher | | Vendor | |-----------------------| |--------------------| | id | | id | | publisher_id | | vendor_id | | name | | name | | address1 | | notes | | address2 | +--------------------+ | notes | +-----------------------+ Sitemap: Questions for elsa: is there a set format for issn #s? are issue and volume always numbers? Questions for jim: