form with some fields set as dynamic constants

[phillip9]

Hello everyone,

I have the following issue, that I hope you can help me with.

I have a truck table and a load table, the truck table has some fields that
are keys to the load table. But, there are also some fields in the load that
are constant for each truck, but different for different trucks. I can do
most of what I want using a subform for load, but I also want to be able to
set these load fields and have them fill-in for each load record

details:
truck table
truckID
checkinStaff
date
time

load table
truckID
itemName
qty
Manufacturer
paletNumber
other fields

I have all the truck info set on the main form and the load table is a
continuous subform with the truckID as the key for both. But for most items
in a particular truck the manufacturer will remain the same. I'd like to set
manufacturer and other fields in a "control/master" section and have those
automatically fill in for each field on the load subform.

If you need me to explain anything further please let me know. Sorry, if I
have not explained this well.

Phill