Auto populating a table...

[Guest]

I am in need of some assistance. I have a table of land use values that I
would like to use to automatically populate the land use designation of the
property in another table.
The land use summary is handled as follows:
Table name: Property and Building Class Summary (PBCS)
Fields (all text): PROP_CL, BLDG_CL, LU General, LU Basic and LU Details

The table that I am trying to populate:
Table name: Citywide parcels
Fields (all text): PROP_CL, BLDG_CL, LU General, LU Basic and LU Details
(note that all the "LU" fields in this table are empty)

What I would like to do is populate the LU fields in my Citywide table by
saying "if PBCS,PROP_CL=Citywide, PROP_CL then display PBCS, LU General in
Citywide, LU General".

I hope that this makes sense. If it does, any suggestions out there?
Thanks,
Greg A.

 

[Joseph Meehan]

I am in need of some assistance. I have a table of land use values
that I would like to use to automatically populate the land use
designation of the property in another table.
The land use summary is handled as follows:
Table name: Property and Building Class Summary (PBCS)
Fields (all text): PROP_CL, BLDG_CL, LU General, LU Basic and LU
Details

The table that I am trying to populate:
Table name: Citywide parcels
Fields (all text): PROP_CL, BLDG_CL, LU General, LU Basic and LU
Details (note that all the "LU" fields in this table are empty)

What I would like to do is populate the LU fields in my Citywide
table by saying "if PBCS,PROP_CL=Citywide, PROP_CL then display PBCS,
LU General in Citywide, LU General".

I hope that this makes sense. If it does, any suggestions out there?
Thanks,
Greg A.

Databases are not spreadsheets. They do things a little different.

In general it is not good to populate any table with data that is the
result of a calculation or is stored in another table. You just calculate
it as needed.

I have not thought through your question, but it sounds like you need a
simple look up table related to the original table.

 

[Guest]

I appreciate the input. Any suggestion on using a look up table would be
helpful also.
Thanks,
Greg A