Table Relationship Question

[BLBurden]

Hello guys, I am back once again. But I haven't been here for a long time. That means that you guys have taught me a lot about MS Access, and I try to figure it out before I come here for help, and the help is very much appreciated.

I know that when you create a form from a table, and if you want to type in one field and have infomation flow into another field automatically you use the example below in an event.

Private Sub IDNumber_AfterUpdate()
Me![Location] = Me![IDNumber].Column(1)
Me![Description] = Me![IDNumber].Column(2)

But I want to know if this can be done just but typing in the table, and not making a form from the table? I want to be able to type in one field in the table and have information flow into the next 2 or more fields.

Is this possible? Thanks for you all help in advance.

BLB - Always Grateful
A good friend will bail you out of jail. A true friend will be sitting at your side saying, "Boy - didn't we have fun?"

 

[willir]

BLBurden

I do not believe what you are attempting can be done.

Moreover, I know several suject matter experts feel quite strongly that data should be entered via a form, and not directly to the table. This allows you to better preserve the integrity of the database.

As please realize in your example, per the rules of normalization, you usually link tables together. Information from the joining table can be displayed on the form, but at the data level, the key is to link the table.

An extrapolation on your example, let us say you have a "attractions" table for the tourist industry.

The attractions table would be linked to a location table. The location table would provided the location name and description. So you can see the attraction information -- let say a bed and breafast facility in Bordeaux, France.

It is linked to the location of Bordeaux with a description for the Bordeaux valley. But the description is not part of the attraction table.

I hope this helped, and did not confuse.

Richard

 

[BLBurden]

Willir , thanks for you response, oh by the way it doesn't take much to confuse me. Nevertheless I will stick to the forms just wanted to know if the other was possibe. Thanks again.

BLB - Always Grateful
A good friend will bail you out of jail. A true friend will be sitting at your side saying, "Boy - didn't we have fun?"