Can I relate one primary key from one table to duplicate foreign keys in multiple tables? (I know, don't cringe!)
For example, say I have a lost and found database where users might lose an item AND find an item. For my own reasons, I want separate lost and found tables and relate them to the items table.
tbl_users
userID (pk)
name
phone
tbl_items
itemID (pk)
item
userID (fk)
tbl_lost_items
lostID (pk)
item
itemID (fk)
date
details
tbl_found_items
foundID (pk)
item
itemID (fk)
date
details
I know the best approach would be to combine the lost and found tables. But again, for my own reasons, I want them separate. In fact, I currently have five tables I want to relate to the items table. Any suggestions?