R
richard
I have a database which has four levels as follows
Clients - leads to
Sites - leads to
Batches - leads to
Samples
The client may have multiple sites and each site may have multiple batches
and so on. (Hope this is clear)
In the input form for batches I have a combo box which allows any batch to
be selected and this then updates the record for that batch into the form,
based on the batch I select, I would also like the client name to be shown on
the form as a reference for users. The clients name is only stored in the
Clients and Sites tables.
As before my knowledge of code is limited so answers in words of one syllable.
Many thanks
Richard
Clients - leads to
Sites - leads to
Batches - leads to
Samples
The client may have multiple sites and each site may have multiple batches
and so on. (Hope this is clear)
In the input form for batches I have a combo box which allows any batch to
be selected and this then updates the record for that batch into the form,
based on the batch I select, I would also like the client name to be shown on
the form as a reference for users. The clients name is only stored in the
Clients and Sites tables.
As before my knowledge of code is limited so answers in words of one syllable.
Many thanks
Richard