Set up a related table linked to your table of CD's. Create one record in this table for each track in the CD.
Okay, I've done this. Fields in my TrackListing table are ItemNo(which is related to the ItemNo on the Products Table), TrackNumber and TrackName. I have created a portal on my Products layout as well. TrackNumber is set as auto-enter serial value starting with 1. I entered the track listing for Product A, there are 12 tracks total. However, when moving on to enter track listing for Product B, the TrackNumber autopopulated as 13 when entering the first track for Product B, but should start with 1 (different track listing for a different Product).
How can I get each Products Track listing to start with 1 and build in increments of 1 for each Product?
It appears that you have set up this relationship:
Products::ItemNo = Tracks::ItemNo
but you aren't limited to a single "box" in the relationships graph for any one table in your database. Add a second Table Occurrence of Tracks and link it like this:
Tracks::ItemNo = Tracks|SameCD::ItemNo
Then your Track Number field can be set to auto-enter:
Max ( Tracks|SameCD::TrackNumber ) + 1
Be sure to clear the "do not evaluate if all referenced fields are empty" check box.
Be sure to clear the "do not replace existing value..." check box.
Repeating fields really aren't a good design choice 90% or more of the time. You just give up way too much flexibility when it comes to working with the repeated data.