Help me start writing a script please

[budgy]

Can anyone put me on the right track please.

I have 2 tables and have tried various lookup options to no avail.

The sample number in TVC Pass layout is a lookup based on all the Sample Numbers in the Sample Entry Layout. The script needs to be able to auto insert the sample details in TVC Pass which matches the details associated with that sample number in the Sample entry layout

Hope someone can help and my description of what I am trying to do is clear. Thought attaching the file would be best as it is easier to see what I am trying to do rather trying to explain. Won't accept the file so if you think you can help I can email the file to you to have a look

Any suggestion of a better approach ie: Portals would be most appreciated. Thanks

[Vaughan]

Zip the file before attaching it.