Search results

Hi, Looking for a push in the right direction :banghead: Objective: To create a Scheduled Work table to show when we work on a specified site and to include materials used/who supplied them I currently have a few tables; Customers, Jobs, Materials, Suppliers. What happens is we have...

hey I started drinking when I clicked 'create blank database' ha Thanks again for your replies, you've really helped me past the design phase. The database is almost done and i've started entering values to test it. Solved; released I can code form fields like excel cells (happy days):D I have...

I think I understand now. tblSupplierPrices: For example- FK-Material(tblMaterials) - FK-Supplier(tblSuppliers) - Price Rubber ---------------------------Aj Rubber Plant--------------- 0.59 Rubber --------------------------Rubber Industries ------------- 0.54 Rubber...

Thanks very much for your reply. I am currently using the access auto number simply for use within access as you said. With the supplier pricing how should I enter the material with the 3 prices without making duplicate information? you may have already answers this but I don't understand...

Hi, New to the forum, I've used access in the past but drawing a blank at the first stage. :banghead: I'm currently trying to build a database to store information of customers, suppliers, products, Jobs (address of job, company who have contracted the works, job ID which has already been...

Hi, ive recently started working for a company and im currently attempting to build an access database, hence being on here. Ive had past experience but seem to have forgot some of it or need a kick to get me going again.....that's about it Thanks for reading and see you around...