Value in List

[jim shelton]

I hope this is in the correct area.

 

We have a portal to where each record the User can select Contact Type(phone, fax, email, cell phone, etc) then they can enter the correct info in the field Contact Data. I need to know if Email is in their Contact Type and if so what value is it so I can locate it in the list of Contact Data.

 

thanks,

Jim

[Wim Decorte]

Not so much a value list issue as related data issue.  The contact info goes into the related records, that's good.  So now you can use the List function to grab the related Contact Type data for any given contact and use FilterValues to figure out if email is in there.  Or you can do a quick GTRR and loop through the related records to see if there is record with Contact Type = email.

Or you can do a search on the Contact Type table for Contact Type = email and Contact ID = the id of whoever you want to search for.

 

So plenty of options.