AnsweredAssumed Answered

Performing a find within a calculation

Question asked by wdockery on Jul 14, 2009
Latest reply on Jul 14, 2009 by LaRetta_1


Performing a find within a calculation


Hello, I'm a little bit new to calculations and could use some help.  One of my layouts of Table X is intended for user input and requires the user to select a company (from a value list of company names in Table Y) that they want to do business with.  On my layout of Table X, I only want to capture the companyID from Table Y.  I am hoping that if the value list pops up and the user selects a company name, I can perform an auto-enter calculation that will enter the correct CompanyID for that company name.  Does this sound like a reasonable thing to be doing from a database design perspective?  Any ideas how to do this?  Thanks--