I can't enter data

[HPC]

Hi everyone,
firstly, I know next to nothing about Access, so this may be a stupid newbie question, however, before throwing the computer out the window, i thought i would consult with those more knowledgable.

I am setting up a database at work to keep track of all our projects.
I have set up a project table, staff table, client table (all linked in relationships), I have also set up 10 other tables. Our business requires the adherance to strict timeframes for 10 different stages. these stages each have their own table with info such as dates, completed and comments. they also each have an ID, which is linked back to the projects table.
this is all fine, i have set up the relationships (and fixed the mismatched errors) everything looks ok (in my opinion) however, when i run the query (all i'm trying to do is get a comprehensive list of info without all the id stuff, so i can make a user-friendly form for everyone to use), it comes up with a table, but when i go to type data in, nothing happens.

I can type data into the separate tables, however it doesn't show in the query, and i can't type...
I don't know what I've done.
when I delete the relationships, and just enter the project ID and the location (of the project), it won't even come up with the table, it will run the query, but no table.

If anyone has any idea what I have done, or how I can fix it, please let me know! I look forward to your comments and suggestions,
Regards,
fiona galloway
harvey property consultants
brisbane australia

PS, i've done a screen capture of my data and put it in a jpg, don't know if it will work, but worth a try,
thanks.

 

[MI Magician]

Hope I can Help

Hope I'm not too late. Looking at your query makes my brain hurt . I have run a few queries myself on a database with the same number of tables as you have but I never created the joins/relationships. I usually leave that part to when I build the query. From what I can see you are using 2 columns so not too sure why on the top part of the query you have soo many tables showing.

If you would like me to have a look at the database let me know. May not be able to do anything but could try for you.

Cheers

Tom

 

[ssmithri]

Fiona,

I hesitate to post without seeing the query/data behind the scenes, however, if you build the form through the form wizard... selecting each field from each table that you need, the resulting recordset might be writable.

I do know that I have never been able to input data to tables in a form based on a query.

Stu

 

[WayneRyan]

HPC,

In your query, you are only selecting a couple of fields from the Projects
table, but you have joined all of your tables in the query.

You should see a message in the lower-left hand corner of your screen
when you try to add info thru the query. Something like "The recordsource
is not updateable".

Remove the extra tables from your query.

Wayne