I have a report that give me information on clients' application details.A new SQL server db has been created with a web front-end and new applications are created.The db connects with a Oracle db to collect other information(using unique key).
There are 3 tables in use
just relevant fields)
SQL: tbl_application:fields;ID(unique)ADDRESS,OFFER DATE,UPRN(unique)
tbl_applicant_occupant;fields; MAIN APPLICANT,ID(unique)
ORACLE: person; FORENAME,SURNAME,UPRN(unique)
The tables tbl_application and tbl_applicant_occupant are linked using ID(this is unique and increases with growth)
The tables tbl_application and person are linked with UPRN, this is unique code for person.
The report is shown below:
ID(tbl_app).Forename. Surname. Address. Offer-Date
This brings back results,however when making a selection of bringing these details where only the main applicant is shown.This is a field in tbl_applicant(sql db)and when chosen by the user,replicates either a 1 or 0 (main app and not respectively).
Now, when the selection is made it brings back the results accurately however the Forename and Surname from the Oracle DB will not appear.
There are 3 tables in use
just relevant fields)SQL: tbl_application:fields;ID(unique)ADDRESS,OFFER DATE,UPRN(unique)
tbl_applicant_occupant;fields; MAIN APPLICANT,ID(unique)
ORACLE: person; FORENAME,SURNAME,UPRN(unique)
The tables tbl_application and tbl_applicant_occupant are linked using ID(this is unique and increases with growth)
The tables tbl_application and person are linked with UPRN, this is unique code for person.
The report is shown below:
ID(tbl_app).Forename. Surname. Address. Offer-Date
This brings back results,however when making a selection of bringing these details where only the main applicant is shown.This is a field in tbl_applicant(sql db)and when chosen by the user,replicates either a 1 or 0 (main app and not respectively).
Now, when the selection is made it brings back the results accurately however the Forename and Surname from the Oracle DB will not appear.