I have a form where Event Promoters can add an event and all the bands/artists that are appearing at that event. The form uses two datasets - Event dataset and Event Artist dataset.
The user should fill in the event details and then add the artists one by one. When the user clicks Add Artist, the artist for appears. When they have filled out the artist for, they click Add to Event, the artist should appear in a list/table, the Artist form will clear and the input elements will be hidden until the Add Artist button is clicked again.
I cant work out how to do this so any help is appreciated.