Data Input Form - automations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to input many new records at a time with several fields that would be
the same or increase by 1 after the first new record input. An example might
be if I were databasing a record collection. You might enter an album
number, a track number and a song title. I want to enter the album number
once, on the first new record, enter track 1 and a title. For the next new
record I would like the same album number to automatically populate and would
like the track number field to increase + 1 so it would read 2. An ideal
situation would also be for the album number to automatically populate based
on the last unique album number assigned and increase it by 1 so if I number
my last album entered 321, when I go to enter a new album, it would populate
my album number field with 322 and a track number of 1
 
Hi Jeff

Create 2 tables
tblAlblums
tblSongs

In tble have these fields
AlblumID = Autonumber
AlblumTitle = Text
AlblumArtist = Text
etc
etc

In tblSongs have these fields
SongID = Autonumber
AlblumID = Number
SongTitle = Text
SongArtist = Text
etc
etc

Open the relationships windows and click the tblAlbum then AlblumID and
drag it onto the AlblumID in tblSongs. Save and close

Use the wizard to create a new form Main form could be single form and have
a subform (continous forms) for the songs. Then when you select an alblum
you will see all the siongs on the alblum. When you ad a new alblum it will
have an incremental number.

Hope this helps
 
Thanks - I am working with your response to see if I can get it to fit my
application - which is actually a database of Karaoke songs. I have a single
table with diskno and trackno fields established. I am trying to create a
form so when I enter a new disk of data, I open the form and the diskno field
would populate with the next unique number and the trackno field start with
1. The second entry would maintain the diskno the same and add +1 to the
trackno field. Thanks for your answer.
 
Back
Top