Hi All,

Hope someone can help!

In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).

I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Proposals linked to the same Sales Opp named Proposal 2, 3, etc. (ie not using an Autonumber field that simply counts all records in a table). Ideally the number will not change if an earlier Proposal is deleted (but not the end of the world if so).

Is anyone aware of a way to do this besides manually?

Many thanks!