Ask Your Question

Revision history [back]

Base: Entering data in a form, a field linked to another table, how to add a new record in second table?

Example file: 1547527483407949.odb

When entering a new record in the "Sales Entry-Maintenance" form, I get to the "Sold_To" field (it is currently a list box) which displays the customer table records just fine. But suppose this sale is to a new customer, not in the Customer table already, how can I program the ability to add a new record in the Customer table, AND do it without having to abandon the current new Sales record, exit the Sales form and go into the "Customer Maintenance" form to add it there?

I still feel like I'm new to OOBase, but I'm gaining experience daily...

Thank you very much, in advance!

Base: Entering data in a form, a field linked to another table, how to add a new record in second table?

Example file: 1547527483407949.odb

When entering a new record in the "Sales Entry-Maintenance" form, I get to the "Sold_To" field (it is currently a list box) which displays the customer table records just fine. But suppose this sale is to a new customer, not in the Customer table already, how can I program the ability to add a new record in the Customer table, AND do it without having to abandon the current new Sales record, exit the Sales form and go into the "Customer Maintenance" form to add it there?

I still feel like I'm new to OOBase, but I'm gaining experience daily...

Thank you very much, in advance!