Please bid only if you have experience with Drupal 6.x, PHP and MS SQL.

My external (non-Drupal) MS SQL database has payment ledgers associated with customer accounts. I want the Drupal user to be able to access their own ledger in this database through their Drupal account.

The first time th user logs in, they need to establish a link between their Drupal account and their ledger in the MS SQL database by comparing their registered Drupal email with those in the database [EmailAddress]. Once their account in the database has been located, a permanent association should be made with their Drupal account and their user ID in the database [Tenant_ID] and corresponding lease ID [Lease_ID]. The Drupal user should then be able to view the entire payment ledger in the database.

My apologies that this description is not more technical.

Please, ask all the questions you'd like in order to make an educated bid. A sample of the MS SQL database is attached.

I would like this project to start as soon as possible.

Required:

Drupal 6.x
MS SQL
PHP
Views 2 module suggested, but alternatives will happily be consideredAdditional Information:

- This project is for a strong, reputable and well funded US-based real estate company, with offices in Baltimore, Maryland and Washington, DC.

- 100% of the fee for the project will be placed into Escrow immediately upon choosing a winning bid.

- When responding with a bid, please show examples of similar work (e.g. Drupal/databse work) that will demonstrate your ability to complete the project successfully.

- This is the first of several Drupal/database projects we need completed. The winning bidder will be heavily considered for all future work as well.