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.
 
Back
Top