How do you enter duplicate titles?

[snowboarder234]

For example, I have two books -- each a duplicate of each other.


ie: Crossing the Line -- book 1
Crossing the Line -- book 2
Both books are the same. I want to document that the 2 identical books are in the database
I'm unsure of how to enter both of these duplicates into the database.

[June7]

Assign a unique identifier to each record. This is what autonumber field can provide.

You might look at the Microsoft Lending Library template database.

[ArviLaanemets]

Autonumber per se may give the unique identifier, but it has very little use in case you have one of books in hands, and have to decide which one in database it is!

You must have some unique identifier attached to every book (e.g. inventory number or this same automuber - generally it is not adviced to make autonumber visible for users, but in this case maybe you make an exception) - written somewhere or printed on some sticker. And you must have this identifier registered for every book in your table.

[Robyn_P]

I'd have one table for the book details and then one table for the instances of each book

[orange]

You might consider the concept of CopyNumber. I have seen this used for Movie/DVD rental applications where there may be 1 or many copies of the same Title, and each has to be managed.
Good luck.

[snowboarder234]

Thank you to everyone who posted. I appreciated your time and help.

[orange]

And do you have a solution to share?