Need help deciphering append/join query in existing database

[AlexJ]

I have received from a third party through a client a database with a series of queries joining tables with civil survey data to other tables with the same data in a different order with room for a few other fields to be filled out in office through a form. My problem is I can't seem to make sense of the existing query that is supposed to run this process. There is a macro that runs a delete query on the "BSD_" table followed by the join query between "SC_" table and "BSD_" table through an intermediate table and a master point table. I've attached a couple screenshots outlining some of the query in design view. The "SC_TEE" table is very straightforward PNEZD data with some attributes, the "BSD_TEE" table contains the same attributes plus or minus a few others (manufacturer, pressure test results, line/series/route numbering, etc.) but with no PNEZD data. I am under the impression this database is ready to use and the query is complete, unless I am missing some sort of data in the Point table that is preventing the join from going through. Essentially I need the relationships and append query process broken down to troubleshoot why the data in the "SC_TEE" table isn't appearing in the "BSD_TEE" table after running the query. I'm not getting any error messages either. Any help would be greatly appreciated.

[orange]

I have received from a third party....

More information required. Did you talk to the 3rd party from whom you received the data?
Why did you receive the data --some sort of contract?
Is there any user/operator usage manual? Did you get any training on the database and related procedures?


For anyone reading this and totally confused with the description.

I found this via Google.

Point Name; Northing; Easting; Elev.; Description (PNEZD) referring to GPS

Good luck.

[AlexJ]

The only thing received from the third party is the blank database. All the relevant data is populated by me using an addon to AutoCAD Civil3D. There is no user/owner usage manual (of course) and asking the creator of the database isn't an option at this time so I am consulting this forum to see if anyone can point out any obvious flaws and help me troubleshoot the append query's process. I have a decent amount of knowledge in databases when used in this context and I understand everything up to and after this point, I just can't get a result from running this query. And apologies for not clarifying PNEZD but you are correct, it is essentially the information that is attached to a GPS survey shot in the field.