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.