I've been using Excel for a while to track shipments and its become unmanageable / messy so im switching to Access.
Heres a picture of what im going for: http://i.imgur.com/VV5IR4B.jpg
I've been able to create a similar database in Access, but not exactly how I need it. Ill have several rows of book titles in each line with their costs but this creates a new id for each book creating a relationship issue. As seen here:
http://imgur.com/a/UanJb
Is it possible to make the cell have multiple lines so I can input multiple rows of information for a single ID?