Core 1 Lesson 9 Person Code - Access Business & Contact Database Core Part 1


	Back to ABCD Core Part 1 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Core 1 Lesson 9 Person Code

Ron VandeVelde

5 years ago

Richard,
The current project I am working on only has 2 possible Organizations in it. I would like to design the code for the Entity Code creation to start with something other than P, I would like the value assigned to depend on which Organization is selected. For example, if I have Organization A and Organization B as the possible Organizations. If you create an Entity with Organization A, the Entity Code would be "OA" + the numbers, if you select Organization B, the Entity Code would be "OB" + the numbers. Can you help me with the IF statement to accomplish that, and where I would need to put it so that it runs AFTER the Organization is selected? Or would that part be easier to just move the the Organization to be the first thing on the Entity Form?

Ron VandeVelde OP @Reply

5 years ago

I just realized an issue with the way I was doing this. I had OrganizationID with a list of the Organization's in the HelperTypeT/HelperT. This was causing me an issue with the Address form with the TempAddress. So if somebody knows what I would need to do to make everything work with my current set up I will just change it to have them have to type in the Organization Name for each entity in a text box.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ABCD Core Part 1.

Next Unseen

New Feature: Comment Live View