In my database, there are two tables. Both have a username column. Table A is stores user information, and Table B is stores users' reservations. In my page, there will be a drop down menu that will retrieve BookingIDs for the currently logged in user. How should they be retrieved?
To help you understand, this should give you an idea of what I mean.
User X login, If User X(Table A) = User X(Table B) Then dropdown1 shows BookingID of User X from Table B.
I am sorry I don't provide any code because I really don't have any idea how to do it. Any answers are welcome. Thanks in advance.
C#
...
Go to the complete details ...