Recognizing related Data within a table

[BritA]

I'm horrible with describing my problem so hopefully I will get this out right. I have a table in which I track packages with and each one has a unique number. If someone returns a package on multiple dates (i send a quantity of 500 papers, they return 200 today and 300 tomorrow), i'm tracking each return package separately and i'm relating them by checking a box saying there is a related package and what package number its related to. I want a subdatasheet to show all related packages. How do i do this?

 

[jackd]

Part of the issue, as I see it, is using multiple terms. Package/paper are these the same thing? Before you get to forms or subdatasheets, step back and get a logical view of what you are doing--"business rules". This is much like creating an "artist's concept of a building" before actually physically building the database.
Here's a tutorial you should work through - it will show you how to identify entities and attributes; how and why to create relationships...

The sooner you go through this exercise, the sooner you'll appreciate database,

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip
Good luck