Help - Design a table with maximum number of variable records?

  • Thread starter Thread starter FourDogs
  • Start date Start date
F

FourDogs

I want to create a table which has at most 7 records linked to each master
key. If an 8th record is to be added for a key, I would like the oldest to
roll out of the table.

Is there a way to do this without writing code to bump through the table
each time records are added?
 
Rather than deleting the records, try using a TOP 7 query to return only the
7 newest records.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber records inserted in gaps 1
Access Compare records in same access table 0
Table Design Question 3
Tables Design 3
VBA: How can I use a string variable as autofilter criteria? 4
To index or not to index 2
Database Design/Combo Boxes and Relationships 2
Adding records with referential integrity 7

Back
Top