Create Reusable calculator

[Scott Pon]

I want to create a pricing calculator for my customer service team. 

I want the layout to ask

Size X: ___

Size Y: ___

Size Z: ___

[submit]

 

based on that information, it will generate a price code.  They will take that price code and enter it into a different database.

 

I don't want this calculator built into the 1 database, because it may be used in other databases, or independently.

 

I was thinking about using a single record.  But if I have 2 people generating price codes, they can't use the same record (IE it would be locked via record-locking.)

 

Has anyone tried to do something like this before?  I know I can do this in MS Access, because i'm not using a record.  Just a text box with no control source behind it.

 

Thanks in advance.

 

Scott

[Kris M]

one possible solution

calc.zip

[comment]

I was thinking about using a single record.  But if I have 2 people generating price codes, they can't use the same record (IE it would be locked via record-locking.)

 

You can use global fields - they are user-specific.

 

 

 

They will take that price code and enter it into a different database.

 

That doesn't sound like the most convenient arrangement for your users;

[Scott Pon]

Thanks. Using Global Fields worked.