Linked fields in Lotus

[uethello]

I'm using Lotus 1-2-3 to create a database. When a person enters a zip code in one field, I want it to automatically be input in another field on the same sheet. These Zip code fields will be for a PO box Address and a physical address. The zip codes will probably be the same, but I want the second field to be able to be changed, manually if needed.

Can anybody help me with this?

 

[SeTeS]

Well, you won't be able to use a formula in the cell AND have the ability to overwrite it cleanly, unless you do something wacky like have a third 'override' field for entry of the zip. The 2nd field w/ the formula would do something like:

if(isblank(3rd),1st,2nd)

If you have smartsuite, try using Approach. It's probably a better solution, and as far as database programs go, it's one of the easiest to learn.

You can also check out http://www.xpertss.com/

You should be able to find more info there on all of the smartsuite components.