I have a requirement wherein:-
There are travel forms which our company uses where they have to enter details like emergency contacats, indirect funding, direct funding.
To start with we have no data in our tables, it is empty. Whenever any person enters any info the tables in the database has to be updated
and then when the second time they enter information it should populate the fields as it is already there in the database.
There are two parameters @Loginid and @Type
Type could be
Travel Coordinator ( AD Login, coordinator name, phone)
emergency contacts (AD Login, Name, phone)
Indirect funding(AD login, departmentmanager name, phone)
Direct funding (AD Login, departmentmanager name, phone)
Phonecustoms (AD login, serial number)
Laptop Customs(ad login, phone number)
TCO(column1, column2)
FSO(column1, column2)
based on the ad login and type get the other details from the table if it is there
there has to be two tables
1. id, ad login, sql query
2. description Column1 column2, column3, upto 10 columns with info such as name, adlogin, phone, manager etc..
The sql query will have the query querying the fields that have been entered.
So there has to be update and read written in the code.
Please advice on how I can go about it.