multiple db presents a few problems
because the information is stored by number in the map so if u delete and add new fields in each db they don't necessarily match.
using actdiag create a db fields report for each DB.
u will probably find that the same field titles have different field numbers for the fields u entered.
when u create the layout in one db then go to the other db it shows u the jumble because the field numbers don't match.
the solution here is to use a different named layout for each db.
Alternately, u could play DB tag and keep the DBs the same as far as fields are concerned.
That would require creating an empty DB of one and exporting the other to it, then making the same
changes in both DBs in the same sequence. somewhat more of a mess.
ALSO, the layout must be SAVED AS a different name and not copied and pasted with a name change.
HOWEVER, that means one of the db will require u to change the layout everytime u open it because that is
a preference and it is controlled by the next problem.
the other problem is that the registry stores the customizations/preferences - not a file in the db.
therefore when u change customizations for one db they will apply to the other db.
u can solve this issue by doing a complete backup of the ACT registry with actdiag then
use a batch file to open each db.
the batch file will first run the REG file for that db entering it into the registry - overwriting what was there - then open the db
If u make a change in the preferences for that db u will need to update that db reg file.
I did this with threeDBs and it worked just fine.
