[pilot-db-list] selecting a list field to fill in other fields

[Steve <ba...@gm...>]

Hi,

Does anyone know if the following is possible?

-select a field from a LIST
-have the database automatically fill in other fields based on what
was picked from the list in the previous field

I'm not sure if this is possible... would I have to use conditional
statements in the other fields to determine what was picked from the
list field? Will this work, or is there even a better way?

The intended purpose is to be able to pick from a list of equipment,
then depending on what equipment was picked, fill in certain data
(specifications) for that equipment, and then perform calculations on
that data.

Thanks a lot for any help!

-Steve.