Jump to content
Sign in to follow this  
EJU5310

Make Fields Relate? Beginner needs help please.

Recommended Posts

Hello,

I'm trying to figure out how to make two fields relate to each other. I have one field called "ad size" which is just text (e.g. "full page") and another field called "inches" where we choose the number of inches (numerically) that go with the field "ad size".

I would like to make the two fields talk to each other, so it is more mistake-proof. I apologize that I am a total beginner, but I can't find anything that answers such a simple question on here.

Share this post


Link to post
Share on other sites

I'm not sure you mean relate since the two fields are in the same table. The easiest way I know of is make your "inches" field a calculation field and use a case function so it is filled automatically based on what is in the "ad size" field:

Case(

ad size = "full page"; 25;

ad size = "half page"; 12.5)

Share this post


Link to post
Share on other sites

You should have a seperate table that stores the ad size type along with the true measurements.

For example:

Normal 8.5 11.0

Landscape 11.0 8.5

Now in your main table, when you go to select the type of 'Normal' (perhaps using a value list), you can either use a lookup or a straight relationship to display the measurements.

Share this post


Link to post
Share on other sites

GoHogs, You are correct, that sounds like exactly what I want to do. Any way you can walk me through this? Again, I am a total beginner and appreciate any help!

Share this post


Link to post
Share on other sites

Just make your "inches" field a Calculation with the result being a number.

Then click options and type what I had before:

Case(

ad size = "full page"; 25;

ad size = "half page"; 12.5;

etc. for as many sizes as you have, changing the numbers to whatever they actually are. At the end, instead of a semi-colon, put in a closed parentheses.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.