Forum Discussion
Steps to remove certain date range of records in Access
I have a database with about 10 years of records. We only need two years of history in the current database. How can I move the older data but keep in case we need to review? Roberta
When you work with Relationships window, also have Navigation Pane open, and drag and drop additional tables that may not show up at first (because they are not related to any others).
A good relationships window should look like this one for Northwind template:
https://support.content.office.net/en-us/media/559a04f2-11b2-44b8-ae4a-92284d1576bd.png
A good relationships window should look like this one for Northwind template:
https://support.content.office.net/en-us/media/559a04f2-11b2-44b8-ae4a-92284d1576bd.png
I dragged the other tables in the Relationship window; however, there are no relationships.
I hate that I cannot attach screen shot.
I hate that I cannot attach screen shot.
The lack of designated relationships is predictable, given your description earlier. We can work on that.
You should be able to add screenshots in a couple of ways, but you have to elect to reply this way on the first screen.
..
