AnsweredAssumed Answered

Add Record via Window

Question asked by mikes on Mar 25, 2011
Latest reply on Mar 29, 2011 by philmodjunk


Add Record via Window


I have 4 fields in Table 2, 3 of which are used as lookup values in Table 1.  When the user is on the layout for Table 1 and enters a name in the field used as the key between the two tables, what is supposed to happen is the other 3 fields fill in automatically as a result of the lookup.  However, if there is no matching key in Table 2, is there a way to display a window that informs the user that the information does not exist in Table 2 and give them an opportunity to enter a new record and fill in the remaining 3 fields in Table 2 via a popup window while still on the layout for Table 1?