Beginner Database Help: Renaming an item

[Access_Lev]

I am a beginner, with no real training in access, working on building a
database using Microsoft Access 2000, but I am running into some problems.

I apologize in advance if I use the wrong terms.

The database is fairly simple, we want a database that includes all the
organizations we work with and their contact information; in addition, we
also want to record every time we've presented to that organization and the
details of that presentation. The database we've created so far does this
using a subform for the details of the presentations.

The problem is that when I want to rename the 'Organization' all the of the
entries in the subform dissapear! How can I change the name of the
organization without hurting the other information?

 

[Jeff Boyce]

The data in Access lives in the tables, not the forms.

"How" will depend on "what"...

It may be that your main form and subform are connected via the organization
name ... if the name is changed, there's no data for that (new) name, so
none is shown.

More info about how the data gets from the tables to the forms, please...

For example, are your forms bound directly to the tables or to queries
against those tables?

And how is your subform connected to the mainform. That is, what are the
fields used in the Parent and Child properties of the subform control on the
main form?


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Beetle]

What is your current table structure, and how are the tables
related?

It should look something like the following;

tblOrganizations
************
OrgID (Autonumber Primary Key)
OrgName
other attributes of the Organization

tblProjects
********
ProjectID (Autonumber PK)
OrgID (Foreign Key to tblOrganizations)
ProjectDescription
PresentationDate
other attributes of each Project

In a structure like the above, changing the name of an
Organization would have no effect on the records in
tblProjects, because it is related by OrgID, not the name.