Please help - query/form pickle???

[benji_styler06]

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 if Album Name is in the correct table.

This is my relationship:

This is my query:

This is what the form looks like but the Album Name fiedl doesnt work:

Iv spent the whole day getting in a pickle :-( any help/advice would be greatly appriciated

attached is my relationships, query and form design

Many thanks,

Ben.

 

[gromit]

Hi Ben -

Not exactly sure what is going on but a few things to check
1. Looks like the name of the field in the Album table is actually "Album Title" not "Album Name". Make sure you are using the right version on the form.

2. Are you enforcing any referential integrity between the tables? This can cause some issues some times.

hth

- g

 

[JoeComputer]

"How" is it not allowing you to enter then Album Name? Is it giving you an error message? Is it not allowing you to type anything in the box at all?

(good idea attaching those images... I'll have to remember I can do that)

 

[Pat Hartman]

I told you in another thread what was wrong with your structure and even provided the correct structure. Until your table structure is correct, you can't expect your forms to work properly.

Please do NOT create multiple threads on the same topic.