Hi folks im having some trouble with a parent reference.I have parent table 'jobs' which has a uniqueID column for all jobs, works fine.I have Child table 'Job Images' created to store multiple photos per job. This child table has a 'JobID column whi...

Having trouble writing the correct expression to sum all child records in and a static column too.Have tried the sum select function with various versions of adding in the static number but nothing.Parent table has a 'total' column with this expressi...

HI, i have a job estimate - job complete app which has an original quote provided to a client but as a specific job is ongoing i need the function to add costs to the ongoing job with the aim to provide a final invoice, im not sure of the best way to...

Hi folks, im new to this but always learning!I have a form to add a new record/row, the form has a drop down list linked to another table with the 'Customer Name'.When i create a customer separately they are given a uniqueID to reference them through...