Can you write a logical if statement based on a data base. So if the information in the database exist it populates and fills out the fields as it does now using look up. If it returns N/A can the field types for each field in that record then be sin...
Thank you. As of now i have it done with a look up to link the data. But can i do it with a formula in the field to automatically link it like look up and if the look up returns empty to switch the field to manully enter the information ?
