Add new customer to table from another form/(table)

[dipzta]

Hi




I want end user to open a new RepairOrder (form), start typing the customer name in the "Customer" field (related to CustomerTable).
IF name does NOT exist in CustomerTable, then add this to the table (either directly in form, or open a "AddNewCustomerForm", whichever is easiest)
IF it DOES exist (by a autosearch in field maybe?) , then put this customers first and last name in that field (in RepairOrder Form Customer field)


Can someone please help, or give me directions to where I can learn this?






Thank you
(I have search hi and lo about this, but am still wondering)

[Bob Fitz]

I would suggest you use a combo box to enter the customer name.
If the customer does not appear in the list you can use code in its Not In List event to enter the name.