# 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 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 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 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 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 on other sites

I'd suggest you listen to John.

##### Share on other sites

All right, thanks anyway guys... this is apparently way over my head. Time to call the pros.

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×

×
×
• Create New...