We have 4 agents in our office, and throughout forms on our layouts I'd like to automatically add their signatures to each layout. I have all 4 signatures as jpeg files, and all agents are assigned a number which is visible on their layouts.

I'm looking to write a script that says: If (agent field) = 3 (agent number), then insert picture at specified location.

Any ideas?

Create a table for signatures where each record has a field for the agent number and a container field for the signature. create a relationship from the table the agent number is displaying from on the layout to the signature table

table::number = Signatures::number.

Then put the signature field from the signature table on the layout. When an agent goes to the layout the signature with the number that matches their agent number will show up.

Thanks Ron!

I have created the table and relationship and fields. I'm a little confused as to where I put the signature files, also where do I put the different agent numbers to get them to correlate with the signatures.

Thanks

Matt

I created a very raw demo file to give you an dea of how the concept works. I can't really tell you much about how to impliment it without knowing more about your relationships and structure. If you can zip and attach your file I would be happy to take a look.

Sig.zip

Ron, it worked, your sample file helped!!

Thanks again!!

Matt