My aim was to use a select query to select from a list where a value was equal to a value in another column as well as add the option to create a “New Entry”, similar to an enum list. Then autofill some following columns. Since this is not possible w...

How do I do a select list as well as add an addition to the list of text in quotations? My select Statement is as follows though I also just want to add an entry to indicate that the user has deliberately stated that the field is blank such as “” or ...

Hey guys, Hopefully I can explain this properly. So I want to copy over data from one table to another of an address field. Lets say table A is the source table and Table B is the Destination table. In Table B the Address field is the key so that I c...