Search results

Hi, I have adapted this code from an example to try and generate an xml output which will export my "Album" table along with related data from my "track" table, but i cant get it to work? think i have the wrong obj names, not too sure on what it should be linked to? any help would be great...

Hi, Im getting really annoyed with myself iv designed a query to display Album ID Album Name Artist Name Genre Label Name Its working correctly but doesnt let me input Album Name into my forms? Not sure if this is a problem with my query? think my relationships are pretty sound but not sure...

thanks for your help, i think iv got it now - see attached. Iv just set up a query for a form to add a new album. its all working apart from the "album title". Its not letting me input data is this due to the ERD? The query works for adding artist name, genre and label name. Not sure why ist...

Thaks for your help, think iv got it now - however my relationship isnt how i intended, please look at the attaced screen shot. Does access determine the right relationships? This is what i want, the parts in red are the wrong type of relationships and im unsure how to change them? Album...

Hi, I did some access work back in college and am now trying to construct a database for which i will use the xml output. Im trying to set up my ERD. These are the tables i have: ARTIST, ALBUM, TRACK, RECORD LABEL, GENRE. The attached file shows my tables set up in access. Im pretty sure it...