Search results

If you need more help with this project, you can get me at deagar@nexnet.net.au

Yes it is - what version of Access are you using? New version with additional tables

1 to Many: Objects table (1) to Parts (or whatever you want to call it) Many table

I think it should look something like this (probably with some refinements) As it happens, I spent the bulk of my working career in the printing industry, so I have a fair idea of what you are after. ps, I object to being called Sir !!!

It looks to me that your table structure is incorrect. You should have an Orders table, linked 1 to many with Operations table, linked one to one with Machines table

Going through what I have contributed to this, I am embarassed to see that I have not thought threw things carefully enough. Thankfully, you have seen through my cunning plan and have ignored most of my suggestions Good luck with your efforts & I thinks it's best if I humbly bow out David

Seperate table for addresses - it was very difficult to keep track of it, but if you have more than 1 address, i guess there is no other option but seperate tables. My biggest problem was when we had to migrate in new company data, it was very easy to get the Customer & addresses out of sync

Don't go there, our ERP system operated this way and it was nightmare to manage. "I still believe I need the following hierarchy" - Well in a global market, you will probably need to add Countries as your 1st level.. and if you REALLY want to to have fun, manage exchange rates !!!!

If I might buy back into the debate...The above is correct! whether your client buys 3 times a day to the value of £000,000,000 or your customer buys once every three years to the value of £1.50, the DATA you need to process the order is the same. You are building a DATA BASE - it belongs in 1...

Ah, I'm on Office2007 Try this one

I remember the ERP system my company used, this was a complex area, we had about 8 different addresses that could be entered to hadle the multiple requirements, but it looked like some double handling to me... I was thinking along the lines of (attached)

My thoughts were for a Residential customer, you would only one entry (in most occaisions) eg Napolean Blownapart - 24 Rue d'Awakening Paris: Company, Billing & Shipping all ticked, so no matter what paperwork was required, criteria would be met. True, it does get more complex when Groups...

Gee, didn't I just suggest that?

Another approach is to create the table in Access, and format the problem field as text and then import into an existing table

Would it not work if you had tblAddresses AddressID (PK) Billing (y/n) Shipping (y/n) Company (y/n) That way, you only need to enter the address once and where the appropriate box is 'true', the correct paperwork can be generated

I think your problem is in your form design. You can't go from tbleNames to any of the 3 final forms without first selecting an activity associated with the Name

Nearly $400,000 for ONE fish !!! http://www.abc.net.au/news/stories/2011/01/05/3107009.htm as a bye the bye, how much do world governments pay for ONE human?????

Add the result of the search query as a subform on the form where the date range is entered

Thanks ever so much gents - I often wonder why I'm such a bafoon sometimes

If it helps, db attached