All,
Please see the attached DB created by another user which I am trying to edit to suit my needs.
I am having 2 different issues which YouTube cannot seem to solve
- I have a tax form which should show all of the cities in which the database has customers and then I will fill in the tax rates for the city/county of each customer. However, I think I went wrong when I tried to make a query to show the cities/counties of each customer and the tax rate shown in the taxes table. I need the taxes form to auto-populate each customers city but this is not working. It only works if you take the city/county info and fill it in on the taxes table.
- I am also trying to create a form to update the pricing of each piece of equipment. If multiple customers have the same model of equipment, I want to update the price of one and that price be consistent with all customers having the same model.
Thanks in advance to any tips that will help, I am very new to access.database.7z.zip
I have renamed the attached file from.7z to .zip. (for some reason the upload was failing as a 7z)
This should be changed back to .7z before unpacking.