Newbies mbeall Posted February 9, 2002 Newbies Share Posted February 9, 2002 This really has to be simple to do, I'm missing something.... I have two files: Organizations and Individuals and a join file OrgInd. In the Organizations file each organization has a serial number (OrgSN) and in the Individuals file each person has a serial number (IndSN). So the join file just is a list of OrgSn and IndSN. There is a portal in the Organization file that lists all of the people associated with it and one in the Individuals file that lists all of the Organizations that the person belongs to (and the obvious relationships between the SN's in each file so that the portal works). I want the user to be able to add a person to an organization via a pop-up menu in the portal row that shows the organization names (not the serial numbers). So I have a value list that holds the organization names (looked up from the Organization file). Here's the problem: I don't see how to get this to enter the OrgSN in the join file instead of the Organization Name. I don't want the serial numbers to show anywhere since they are meaningless to the user. The first column in the portal needs to be the organization name not the serial number, but if I do that (and format it with the value list), then it enters the organization name into the join file for that record rather than the OrgSN. I have a hack that sort of works, I define the value list to be the OrgSn + Name and then overlay another field on that that looks up the Organization Name, but if you're editing the record, this then shows the OrgSN rather than the name. It seems that I need a value list that displays one thing, but has the value of another, but I don't get how to do this. Link to comment Share on other sites More sharing options...
This topic is 7720 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 account
Already have an account? Sign in here.Sign In Now