Create table and Query

[smtazulislam]

Hello,
We are a small business in local area. COVID19 effective in our business, now our head office to comminication all of branch and retail store by Zoom apps. We try to connection with all of Municipility/UnionParishad>Ward > Municipility area / Village Area > and each shop owner.

We are contact with shop owner/Keeper for two kinds issue: product complaint and our represatative they're follow up week product expiry date or not.
search query for depend each combo box
1. CboDistrict >
2. CboSubDistrict >
3. CboMunicipality/UnionParishad >
4. CboWardNo >
5. CboMunicipalityArea/UnionParishadArea >
6. Textbox ---

 

[Jjaeger14]

So your question is how to create tables with the fields you list above? or is it how to create the database in general? To create a table, open access and start creating a table. Add the field names and choose the data types. close and save the table with the desired name. To go back and edit the table, right click the table, choose design. Edit the table.

 

[smtazulislam]

So your question is how to create tables with the fields you list above? or is it how to create the database in general? To create a table, open access and start creating a table. Add the field names and choose the data types. close and save the table with the desired name. To go back and edit the table, right click the table, choose design. Edit the table.

Thanks for your reply
I already create table you see it first post. I want to query for search and relationship

 

[mike60smart]

Hi
Can you upload a zipped copy of the database?