AnsweredAssumed Answered

Lookup based on field entry

Question asked by user17887 on Oct 9, 2012
Latest reply on Oct 10, 2012 by philmodjunk


Lookup based on field entry


     I have two fields that are related to each other in the same table.  I want to assign a particular number to a record either  from a drop down list using a value list or ny just auto entering the number if it exists.  At this point I qant to populate a description field based on the number selected.  If that number doesn't exist, I want to manualy enter the description.  Any new records created will have the number and description linked that were entered in previous records.

     I think I need to create a second table and relate the number and description but I can't figure out how to add the number and description to the table on the same layout if the record doesn't exist.