Append Query Question (1 Viewer)

[denileigh]

Hi all! I hope I can explain this right and I'm not sure if it's even possible but here it goes.

I have several tables. A job table (customer name, job number, item number, etc) and a job detail table (description of the repairs, codes etc) which can be up to 80 lines per job).

The job detail table pulls fields from the job description table, code table, etc. We are in a business that has all these codes needed in billing so basically each set of codes has it's own table and all of that pulls into the job detail.

My question is this......

We have a contractor performing services for us that we need to import into the job detail table.

How do we import into the job detail table as a whole without all of the codes/descriptions duplicating??

I hope that made sense. Thanks for any help!!

 

[jdraw]

I don't think readers have enough info to be specific in a response.
You have a JobTable with CustomerName, ItemNumber ... but we don't see a Customer Table. Also, what is an Item?
It would be helpful to readers if you could tell us more about your database set up. How is the contractor creating the info? Have you done some sort of mock up/sample to see what is required to bring data into your database? You might have to concoct some custom codes for the contractor, then adjust to your "real codes". Depending on how the contractor is capturing info, you may supply him/her with a copy of your reference tables.

I think the only way to know for sure is to do a mockup. Create a test scenario to mimic what you want the contractor to do. Then determine/ refine the process so that you can import the data the way you need it.

Good luck with your project.

 

[denileigh]

I probably didn't word all that right. Basically there are many tables full of data and codes all pulling information into the job detail table.

If they send a .txt file to pull into the job detail table is there a way to do it without creating duplicate values in all of the tables pulling into that one.

For example - the "Car Inspection" job description which is usually standard in every job.