In Reply To:
Alternately, is it possible that the DJ field is automatically filled in after they've signed in and ready to add another playlist. Then the field would be there, but less chance for input error.
If you have set the
$auth_user_field in the playlist database, the username will automatically be entered into the field when the record is added. You can even make it a hidden field, if you want.
In Reply To:
What I really want is a list that combines elements from both playlists.
That's where the relational part comes into play.
You have both databases working correctly, yes? Or were there some other issues that still need to be dealt with?
Assuming everything is going okay, you'll need to add the "switch_to_" subroutines to db.cgi. The instructions are at
http://www.jpdeni.com/.../Mods/relational.txt. If you need help with it, I'll need to know your field names for both databases. We'll work it out together.
Once we get the subroutines written, you can add code to sub html_record that will list the playlists for the DJ. It'll all fall into place.
JPD
http://www.jpdeni.com/dbman/