User Defined Fields

[awwii]

First off thank you for taking the time to read this post...but let me go ahead and dive into my problem/question.

I am defining a database in which I want a user to be able to control some of the caculations by defining the values in those caculations. Also I want the user to be able to give a "name" for the field. Basically here is what I want:

Fields To Be Defined "Field 1" "Multiplier"

Fields To Receive Data "Amt 1"

Fields Displayed on Form (Field 1 Text) (Amt 1) (=Multiplier*Amt1)

The user will Define the values for the Field 1 and the Multiplier one time (can change in future). The Amt 1 will be imputed daily in the form. The (Field 1 Text), (Amt 1), and the caculation result (Multiplier * Amt1) will be displayed on the same form.

So Using the Same as Above:

Fields To Be Defined "Match $5.00" "5"

Fields To Receive Data "10"

Fields Displayed on Form "Match $5.00" "5" "$50.00"

Now if the user comes back is decides to change these fields from:

(Field 1) "Match $5.00" to "Match $10.00"

(Multiplier) "5" to "10"

I want all previously saved records to retain the Match $5.00 data and any new records created after to have the Match $10.00 data.

I have been playing aroud with this and can't seem to make it work. I have used two seperate tables. Used global fields. Used repeating fields. I have even dived into reationships.

Any and all help on this matter will be appreciated.

Thank you,

[CobaltSky]

Hello Allen,

From your description, it sounds as though you are trying to do something along the lines of what is shown in the attached file.

UserDefined.zip

[awwii]

Ray,

Thank you very much for the attachment, works mutch better than words. This is exactly what I was looking for. I appreciate you response on this matter. Once I compete my database I will try and remember to send to you.

Thanks Once again,

Allen