Hi,
I have a database with the following tables/ relationships
tblmembers has member_id(autonumber)
tblalbums has album_id (autonumber)
tblsongs song_id
the member_id is a foriegn key in albums table
the album_id is a foreiegn key in the songs table
I want to do something like mp3.com:
If someone uploaded 1 album with say 10 songs, I want to find out the new album_id then pass that value in to the songs table as the album_id that way when I query the DB I can have check for all songs with 'x' album_id that would return all songs for that album...I would also need to maintian that same album_id for all 10 song records added...any suggestions guru's
Also I have found posts on the net that talk about a way of getting the max record number and incrementing by 1 but there are problems when 2 users are adding records at the same time....
I have a database with the following tables/ relationships
tblmembers has member_id(autonumber)
tblalbums has album_id (autonumber)
tblsongs song_id
the member_id is a foriegn key in albums table
the album_id is a foreiegn key in the songs table
I want to do something like mp3.com:
If someone uploaded 1 album with say 10 songs, I want to find out the new album_id then pass that value in to the songs table as the album_id that way when I query the DB I can have check for all songs with 'x' album_id that would return all songs for that album...I would also need to maintian that same album_id for all 10 song records added...any suggestions guru's
Also I have found posts on the net that talk about a way of getting the max record number and incrementing by 1 but there are problems when 2 users are adding records at the same time....
