Adding field to existing record

[MrMitch]

Is there a way in a form to have a text box setup to add a new field to the record it is accessing at the time? If so, how would I go about setting that up? Thanks.

 

[missinglinq]

Exactly what are you trying to do here? Adding fields at runtime is usually a very bad idea, and should be avoided.

Linq

 

[MrMitch]

I have records that have a field for a currency total. However, in the future there will need to be amounts added to that record in a seperate field to show additional amounts. Would it be better to have these amounts go into a seperate table? In the end, I need to show a report that can provide the end user with the original total, along with each additional amount (if there is any), and be able to sum those totals up together.