create a lookup and editing form for an Access database table
Budget: $30 – $250 USD
Our clients have a Customer database which they need to be able to add/delete/edit.
They should be able to search by Customer Number (CustomerNumber), Customer Name (CustomerName), City, State (Region), or Zip (PostalCode).
One of the frequent issues is that when a user enters a new Customer into the database, they sometimes duplicate an existing customer. We’d like a way to avoid this, possibly by showing Customers with similar names. Also, if they try to enter a new Customer and they end up having a similar Street Address (Street1) then that should raise a warning that it could be a duplicate.
I know a lot of bidders don't read the description so if you don't state that you saw this line and mention "Allegiance" then you're bid won't be considered.
When the user looks up a customer, they should see all the fields from the database.
They should be able to search by Customer Number (CustomerNumber), Customer Name (CustomerName), City, State (Region), or Zip (PostalCode).
One of the frequent issues is that when a user enters a new Customer into the database, they sometimes duplicate an existing customer. We’d like a way to avoid this, possibly by showing Customers with similar names. Also, if they try to enter a new Customer and they end up having a similar Street Address (Street1) then that should raise a warning that it could be a duplicate.
I know a lot of bidders don't read the description so if you don't state that you saw this line and mention "Allegiance" then you're bid won't be considered.
When the user looks up a customer, they should see all the fields from the database.
Related categories:
Microsoft Access