Update Query

[S4Aero]

I'm getting closer on this new database, table relationships and field names
in the tables seem to make sense now - thanks to all whom have helped - esp.
Mr. Vinson who helped me see the light.

Now, what I want to do is create a query that the user will enter an "event
name" and hopefully the query will update a field in several tables.

Cab this be done? How?

 

[John W. Vinson]

I'm getting closer on this new database, table relationships and field names
in the tables seem to make sense now - thanks to all whom have helped - esp.
Mr. Vinson who helped me see the light.

Now, what I want to do is create a query that the user will enter an "event
name" and hopefully the query will update a field in several tables.

Cab this be done? How?

Well... SHOULD it be done?

Using the Grandmother's Pantry Principle, the field should exist in only ONE
table.

What tables do you want to update? What field? What should it be updated to?
What's the rationale for storing a field in multiple tables?

 

[S4Aero]

The rationale is this - The "EventName" (given a different name in each
field) is the single common identifier in multiple forms. Several users will
be inputting data and producing reports. The forms need to give the
unsophisticated user confirmation that they are entering the data into the
correct record(s) through multiple forms into the various tables.

It's not too late to make some changes, but I think I've got the tables
nailed down as far as the pertinent data, and the forms all make sense as
well.

 

[S4Aero]

OK - i'm proving that a little knowledge can be REAL dangerous - I got to
thinking about what John said, so I figure I can add an unbound text box to
the forms I need and give it a control source back to the table with the
event name. Smart (I think).

During that time I figure I don't need the ControlID (autonumber field) I
set up as tghe primary key so I deleted it and named a new primary key.
Access said "you're nuts" so I re-entered the ControlID field and made it the
primary key again. All back to normal. Right? WRONG.

Now when I open the form it asks for a ControlID parameter value and won't
accept anything entered. Plus the unbound field is giving me a #Name? error
even though the control source is set to the proper table and field.

Sheesh!