Recent content by reverentcreature

Hi, sorry I was trying to keep my question short and to the point. The database is for a small security firm. The parts table stores the cameras, door entry system, etc and the stock table will hold the quantity of these parts for each engineer who has their own van. When a job is completed...

Hi all I have the following tables in my database where I am experiencing problems figuring out what I need to do TBLJOBPARTS JobPartJobID JobPartAction JobPartPartID (foreign) JobPartQuantity TBLPARTS PartID (Primary) PartMake PartModel TBLSTOCK StockPartID (foreign) StockEngineerID...

Hi there, You were right the query when run had more entries that there should have been. Before I created the subreports I had ALL the tables I needed in the main query for the main report Invoice.:o But when I created the subreports A (tblJobParts and tblParts) and and subreport B...

Hi Dkinley, I did consier the option of summarising the rows but because its in invoice I really want to list each individual item. If I open the subreport it lists all the parts for every job thats ever been done. The data only appears once though. Because its linked directly to the table...

Hi all, Im having problems with printing two subreports on a report. The main report contains a Job and a JOBID field. The two subreports are linked JobLabourJobID and the other JobPartJobID. The report displays the correct data and rest of the database works as it should but when you go to...

Hi Alan, Thanks for the link. It was very informative. I think Im on the right lines. But the tutorial uses a blank form with two unbound combos. Im not sure how to incorporate that into my database. Currently a user enters the PartID into the foreign key for JobPartsPartID in the JobParts...

Hi PCGUY. If you want the contents of your combo box to change you will need to create a table and link the table to the combo box. You can link the childrens names table to the field(combo box)on you main table by using lookup tab on the table design screen, choosing combo and adding your...

Hi all :), Im making a database to log and close down calls for a security company. I have a closedown form for the Jobs table for entering the job details and subform on this for the JobParts which links the Parts to the job so that quantity and price etc can be added. Currently you can...