I have a form that displays info from a db. I want the form to start empty and then be populated by using the quick search function. I've looked at macros but I haven't found one that does what I want. I noticed the sc_exec_sql but I'm not sure what to query. If I look for nulls it won't work because the db has no nulls and I obviously can't insert null records. How do I achieve this? I can use "use title" on a select field to display what I want but that isn't available for a regular field.
Login or Sign Up
- Log in with