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

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
 
R

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating related Records in Subform 4
Primary and Foreign Keys 8
Which Foreign Key in which table? 16
Using a single form to enter data into two related tables 5
Two PK in a single table 7
problem in accessing fields from table with multiple foreign keys referencing single primary key 1
Multiple tables to single key in related table 5
Using a combo box to change a foreign key relationship... 4

Top