tables in access

Associate
Joined
10 Jan 2006
Posts
483
i currently have 3 tables all the same apart from one is bookid, the other is journalid, and technicalreportid. all 3 tables have fields, name,author,year published. how can i link these tables to use effeciently in access. basicdally i am creating a database where peopel take out books
 
Soldato
Joined
23 Dec 2002
Posts
2,806
Location
Bristol
i currently have 3 tables all the same apart from one is bookid, the other is journalid, and technicalreportid. all 3 tables have fields, name,author,year published. how can i link these tables to use effeciently in access. basicdally i am creating a database where peopel take out books

this should be in HTML, Graphics & Programming.

try normalising you DB, if all the tables are the same then then should all be 1 table.
 
Soldato
Joined
8 Feb 2004
Posts
3,562
Location
London
Sounds like a homework assignment.

Anyway, what I would do is create two new tables to replace the existing 3 tables.

New table 1: ItemTypesTable
Fields: ID, Description
Example data:
1, 'Book'
2, 'Journal'
3, 'Technical Report'

New table 2: ItemsTable
Fields: ID, ItemTypeID, name, author, year published
Example data:
1, 3, 'Tech Report 1', 'J Bloggs', 2001

ItemTypeID would be linked to your ItemTypesTable.
 
Top Bottom