Recent content by JohnDC

Ok, I shall give it a go - forgive my ignorance still learning!! ;) Cheers all John

Hi Mike If I dispense with the backward part ie attachment to door list, I could simplify it very much. So now I would have a Door which can have many attachments on it, these attachments would not be grouped. So the table would have the following fields: Item description Cost of item Quantity...

I sell doors to big airports, I am developing the system from quote to delivery, I have completed the quote system in Excel VBA, now have come to the costing, at present a price is plucked out the sky and given to the door. We do have sets of assemblies, but the problem is we make bespoke doors...

OK - so what I really have is a One (door) to Many (attachments) to Many (sub-attachments). From this I can run a query to find out what doors they equate to. If this is the case (which it looks like it is) how can I attact the items easily to the door, BarryMK has produced an answer, but there...

I would like to agree with the hinges part, but the doors I produce have different style hinges (H209 and H92), this rings true with all the other attachments, I have different types of letterboxes, handles etc. Which indeed makes everything a nightmare. I would like to view both ways i.e. What...

That is true, I was looking at it both ways, but yes you are right it is One door to many attachments and one attachment to many doors. Simple when someone points it out. Cheers Rabbie

That is brilliant, thank you very much. I was going to do this in Excel, but this has saved my life!!

Thanks for the quick reply, I have just expanded on my information as it may be a bit misleading, I would still need to add the quantities, i.e. 3 hinges, 2 handles etc. Breaking them into groups is a good idea and I am going to give this route a try.

Hi there My problem is simple and I know what I want to do, but have no idea how to do it. Problem: I have two tables Doors (277 records), attachments (60 records), each door can have numerous attachments with varying quantities and obviously numerous doors can have the same attachments (many...