Create a new Customer from Invoice automatically
I have a Customer Table and an Invoice Table. When I type the Customer Name into an Invoice, I want my db to lookup the customer information and add it to the invoice. That part works just fine.
The problem is that if a customer by that name doesn't exist, I want the db to create a new record in the customer table with the new name. I have a button that does this now, but there's no way for the user to know if they need to press the button without looking the customer up manually (which somewhat defeats the point).
I've checked the box in the relationship table saying that Invoice can create records in Customers but that didn't seem to do anything.