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.

Greg A. wrote:
> 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.

--
Joseph Meehan

Dia duit

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

"Joseph Meehan" wrote:

> Greg A. wrote:
> > 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.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>