Recent content by LzAnn

Thank you very much for your reply Trevor G. Sounds great, but I'm not sure I understand fully - could you possibly explain in a bit more detail?

Greetings all database workers, I am still working on the table structure of a database to help my dad and brother with plumbing estimates. There are three tables relating to the Products table to store product details, defined as ‘Descriptors’. The descriptors are: Size, Angle, Flowrate...

Re: Query Thank you both. I should have investigated/thought about it more before posting a thread, sorry.

If these assumptions are true, then the fact that tblTypes is not related to any other table will create a Cartesian Join type. This could be the source of your problem. Check it out and get back to us.

Hi MSAccessRookie, Thank you for your reply. Yes, you were right about which tables I was referring to. I suspect the table structure of the database still isn't right in order to do what I hope. The query is to populate a combo box to list only values that the user needs to see, i.e...

Hello everyone! Am trying to create a query to combine relevant product data. Had lots of help on the tbl structure, thank you (jzwp22) :) The following fields return relevant products perfectly. ProductID, from tblPrducts ProductCode, from tblProducts ProductName, from tblProductNames...

Re: Designing Forms...(well almost) Thank you very much for all your planning, advice and table structures jzwp22. Having described the project and liaised with you, I've been able to create this database structure, as attached (would absolutely not have been able to do it myself!) :) Hope...

Thank you kindly Jzwp22. Apologies for any repetition! We had a big discussion and hope to clarify the pricing side of things. We concluded that: - He does buy exactly the same products from multiple suppliers. - Although, like any business they have a profit margin, they don’t have a...

To help with part of a larger project, one facet of estimating for plumbing jobs: A building can have many Soil Vent Pipe (SVP) stacks. Each stack feeds a certain number of bathrooms and kitchens. Each SVP is numbered on a drawing, SVP1, SVP2 , SVP3 etc. The list hand written for each estimate...

I have put 'CompanyID' as a foreign key in the Products table to tie up products with suppliers - does this seem the best place for it? This creates a one-to-many tblCompanies and tblProducts. Could I also include manufacturer in tblProducts and relate in the same way? Sorry if these...

Product Confusion Thank you very much guys – you have done so quickly what I have been pondering on for months! To include manufacturer is important. They do use unbranded fittings too. Companies make lots of fittings that essentially do the same job, are of the same type. When you say ‘the...

Wow. Thank you. They buy the same products from many different suppliers. Some suppliers use the manufacturers product code as their product code, others use their own product code. Sometimes Product name is unique (boilers tend to have a model no and name) however, with other items, product...

Thank you very much for taking the time to look at the DB :) I was advised to create lookup fields to make life easier! oh well! :( Now removing lookups and am incorporating your tbl layout :) As I inputted product details, I found I was repeating data, therefore created the additional...

Thank you everyone for your help - been pulling my hair out with this! The reason I say 'more tables to come' is because there are distinct sections for each estimate, so, because I'm finding it complicated encompassing everything at this stage, at the moment I have focused on just a couple of...