Column information

[Guest]

I have form that is tied to a table that tracks the amount of product in a
tank. There are 5 of these Above-ground Storage Tanks (ASTs). When the user
opens the form, I would like for the ProductTank fields to automatically
populate with these values AST 1 through AST 5, and have data entered for
each tank (whether a 0 or a value). I know how to require data entry, what I
am not sure about is prepopulating the Tank field.

Thanks in advance!

Larry G.

 

[Joseph Meehan]

I have form that is tied to a table that tracks the amount of product
in a tank. There are 5 of these Above-ground Storage Tanks (ASTs).
When the user opens the form, I would like for the ProductTank fields
to automatically populate with these values AST 1 through AST 5, and
have data entered for each tank (whether a 0 or a value). I know how
to require data entry, what I am not sure about is prepopulating the
Tank field.

Thanks in advance!

Larry G.

Could you describe your table structure. It sounds like your problem is
normalizing the database structure not automatically populating fields.

Give us a sample of a couple of records as well listing the values for
each field (use dummy numbers if you like)