M
MN
Hello all expert,
I using Access2K, table link ODBC with MS SQL2K Server.
Main form Sent Mail have ClientID (Pri-key) form have button Sent .
When the user click the button Sent it will check in the database with this
ClientID in the table dbo_letter, and dbo_mon.
If ClientID in the table dbo_letter then open Form Edit with the information
of the table dbo_letter.
If ClientID in the table dbo_Mon then it open Form Edit with the information
of the table dbo_Mon
Structure of 2 table dbo_letter and dbo_Mon is diffrent.
How can I do this? Please advise,
Thank you
I using Access2K, table link ODBC with MS SQL2K Server.
Main form Sent Mail have ClientID (Pri-key) form have button Sent .
When the user click the button Sent it will check in the database with this
ClientID in the table dbo_letter, and dbo_mon.
If ClientID in the table dbo_letter then open Form Edit with the information
of the table dbo_letter.
If ClientID in the table dbo_Mon then it open Form Edit with the information
of the table dbo_Mon
Structure of 2 table dbo_letter and dbo_Mon is diffrent.
How can I do this? Please advise,
Thank you