Search results

Thanks for the input. In that case, would it be against normalization to have tables that store basic product details and other joining tables that have sub-option data?

Hi Everyone, I need your advice on table design. My company has a price catalogue with about 15 products. It is only available in an awkwardly formatted excel or PDF file format. I would like to add this to an Access table and query what I need. Each product may have 1 to 15 sub-options...

Thank you for your help. So are you saying that a 'junction' table is unnecessary?

While reading another post I have determined that it most likely will be a MtoM relationship. Thanks for your help. Lots to learn... :-)

Thank you for the quick reply. I will combine the two tables, but I'm not sure how to reference two records from the customers table to one order form. The way I plan to create an input form is to use a query from the Orders table and from the Customers table. I will also use a subform for the...

Hi All, I’m new to MS Access. I am working on a project to improve an internal quotation process. My company is a manufacturer and reseller of products to the industrial sector. We often have customers from all over the globe asking for quotations on our products. A typical request may have...

CJ_London, thank you for the suggestion. I will try the date formulas and if I encounter any problems I'll start a new thread. Thanks

Hi Everyone, Thanks for welcoming me. I have learned a lot from reading previous posts on this form and am exciting about using access . I have addressed the problem I posted in this thread by splitting the query into two separate queries. The first query provides a value that the second query...

Hi Everyone, I'm a beginner Access user and have built a small database to track small projects and issues I need to manage at work. I have a query that retrieves a list of all "Open" issues/projects that I'm working on. I've added a couple of columns in the query to calculate the age of each...