Please help - query/form pickle???

benji_styler06

New member
Local time
Today, 05:27
Joined
Mar 20, 2006
Messages
5
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:

bens_ERD_ver3.JPG


This is my query:

query.JPG


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

form.JPG


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.
 
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
 
"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)
 
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.
 

Users who are viewing this thread

Back
Top Bottom