updating primary key and foreign key fields in two related tablesin a single step?

  • Thread starter Thread starter samah
  • Start date Start date
S

samah

access 2003. win xp.

sorry to ask what seems to be a stupid question but I am a beginner and
a confused person.

I have two lookup tables for entering customer address info in my
customers tables. The structure of the lookup tables:

1. tblCities
CityName (pk-single field table)

2. tblBlocks
BlockNo (pk)
CityName (fk)

1-m relationship. (Each city is divided into many blocks). Is it
possible while updating the City Name in the main form, to update all
related block numbers for that city in a sub form?

TIA.
-samah
 
samah said:
access 2003. win xp.

sorry to ask what seems to be a stupid question but I am a beginner and a
confused person.

I have two lookup tables for entering customer address info in my customers
tables. The structure of the lookup tables:

1. tblCities
CityName (pk-single field table)

2. tblBlocks
BlockNo (pk)
CityName (fk)

1-m relationship. (Each city is divided into many blocks). Is it possible
while updating the City Name in the main form, to update all related block
numbers for that city in a sub form?
Click to expand...

If you set your relationship to cascade updates that will happen automatically.
 
Back
Top