Matthew R White Posted October 26, 2011 Posted October 26, 2011 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?
Ron Cates Posted October 26, 2011 Posted October 26, 2011 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.
Matthew R White Posted October 26, 2011 Author Posted October 26, 2011 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
Ron Cates Posted October 27, 2011 Posted October 27, 2011 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
Matthew R White Posted November 4, 2011 Author Posted November 4, 2011 Ron, it worked, your sample file helped!! Thanks again!! Matt
Recommended Posts
This topic is 4785 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now