Access 2003 - query based form design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I am trying to do is this.

We have 6 tables that need to have records updated all at once.

1 table is the primary with a primary key the other 5 have one to many
relationships.

In access 2000, i would just create a query that has all of the fields that
i needed and then create a form based on the query and I was fine.

However in Access 2003 it tells me that i can't do that.

I need the relational database and not a flat so I need to get it figured
out.

Does anyone have any good ideas on how to continue.

Thanks in advance
 
It doesn't say anything. It just beeps at me any time I try to enter text in
any of the fields and it won't let me scroll through the records.

In the query view it won't let me add records there either.

The documentation I have read has stated that I should try using subforms,
that has never worked really well for me.
 
hmmmmm. That is almost as good a reason as "None of the above"

Is this in jet or real SQL?

Are there any sums or group bys (I would guess not, judging by your
description.)?
 
It is Jet,

to be honest it is just text fields, the reason for relational versus flat
is because we want to separate dept fields.
 
In the relationships do they all say show only if equal


Are 5 of the tables linked off of one single table or are they daisy
chained.?
 
The relationships are setup with option 2, where all records from Main table
and only records that match joined field from related tables.

Also 1 main table other 5 related to main table, in fact all tables are
matched off same field in main table
 
That is why it will not work. There is at least one of those tables
that does NOT have a matching record and consequently it would have to
create a record if it let you try to update it.

I can't answer whether 2000 would have let you do that, but my
experience has been that 2003 will NOT let you update on that type of
condition.
 
I would almost be willing to bet that if you made it so that it ONLY
selected those records that had a record in ALL of the tables then you
would be able to update.

Of course you would NOT see all of the records that only partailly
qualified.
 
Actually all of the tables have matching records. We are still in development
and testing so i made sure that the test records are matching.

However I set the relationships to Option 1 like you suggested, still
doesn't work.

I really do apprecaite you trying to help me with this.
 
I guess my next suggestion is to start with the main table and add 1
table at a time to see if it is a certain table or number of tables.

I just did it with two tables and it went fine and allowed updates.

Keep adding one at a time until it won't let you update. If it fails on
table 3 then replace it with table 4 then 5 to see if the problem is
the number of tables or maybe just table 3. May not solve the problem
but give you more information to share so that it may ring a bell will
someone.
 
Back
Top