Good Morning,
I want to know how to Look up and open form to add record is the entered record is not available.
For example, I want to create Purchase List Database and it has "vendor details" table containing "Name" field. I also create form for that "vendor details".
I want to create "Purchase List" data and it will have "Vendor Name" field that is linked to "Name" field from "vendor details" table. In that field, I want to use look up to check if the record is available or not and open form to add new "vendor details"record if it is not available.
Thank in advance.
I want to know how to Look up and open form to add record is the entered record is not available.
For example, I want to create Purchase List Database and it has "vendor details" table containing "Name" field. I also create form for that "vendor details".
I want to create "Purchase List" data and it will have "Vendor Name" field that is linked to "Name" field from "vendor details" table. In that field, I want to use look up to check if the record is available or not and open form to add new "vendor details"record if it is not available.
Thank in advance.