Hi,

I've run into a brick wall while trying to develop my solution. I'm making a simple contracting managment system with couple of tables "contracts", "contract_articles" and "contracts_lines" similar to regular product/invoicing system.

However there is one special feature I want when creating new contracts: I want to automatically insert client and price data (from external table) into contract articles where appropriate. For example I would select "Price and payment" article from contract_articles table and insert price into article text. First I thought I would be able to use some sort of variable inside article text which would be then replaced with proper data. But I guess this is not possible.

Do you guys have some advice on how I should handle this problem?

Thanks in advance!

I'm not quite sure if I understand your question, but if I do then this might help...

http://www.briandunning.com/cf/831

I'm not quite sure if I understand your question, but if I do then this might help...

http://www.briandunning.com/cf/831

Thanks! This looks to be exactly what I need. Now what would be the best way to perform this function on my text? I imagine I could run it with script triggers or maybe when I generate contract for printing?

I don't know what will work best for your database, but here are a few ways to perform it:

- custom menu: perform script on New Record

- script triggers

- button on layout

- have a separate calculated field

Great! I'll try with script triggers first and see if that works alright.

Thanks again!