2 different DBs.how they can interact to one anoth
i feel i am in big trouble and the project deadline is on its way.
i have used the loging wizard to create passwords and uernames. this will automatically will create a database name called ASPNETDB.
i also created a database, with two tables one to insert details of hotel details, this include(hotelname, hotelID...) and another one called request table where the hotel can request waiters to work for the hotel. request table has( requestID, hotelID (forign key), timeIN and TimeOut...)
my problem here how can i assign the hotelid automatically in the request form once that particular hotel manager log in and want to add a request. in another word say i am a manager in hotel when i log in and go to type a request in the request form, automatically my hotelid should be assigned for me in one of the textbox and should only be read only
as you can see the details of the login user is in one database and the details of the hotelid and request id is in another database (second database called ECB)
can anyone help me please???