I currently have an Excel spreadsheet into which I plug figures. The spreadsheet uses the "lookup" function to return some other figures from a second spreadsheet based on the figures I enter. I then print out a summary page and provide to prospects and clients.

I would like to be able to develop a DayLite form into which I would enter the original figures for each instance which would grab the corresponding figures from the Excel table (or some other array) and plug them into the form. I would then use the form to generate my client report, all inside of DayLite.

Can anyone tell me how to reference an external array (preferably my Excel spreadsheet lookup table) from within a form in DayLite, then store the resulting lookup figure there? Thanks!

Bob