Importing fields

[tallboy755]

It may be a reallllllllllly long shot ... but is there any way to import created fields from one database to another???

[spb]

Not really, but there are some workarounds. If a field in dbA is a complex calculation, you can select & copy the whole calc to clipboard. Then in dbB, make a new calc field and paste in the calc (assuming all calc references are to fields with the same name). This is very useful for making a complicated calc field in one db, then duplicating it in a bunch more.

If dbA has, say 30 out of forty fields you want to "import" into dbB, you could make an empty clone of dbA, delete the ten unwanted fields, then create the fields in dbB that aren't in dbA. Then import all data from the original dbB into this new db, rename it & delete (or archive) the original.

If there are too many fields not common to both db's, then you're probably out of luck. It'll be a bunch of work one way or the other. You *can* import scripts (assuming field references are in order), and copy entire layouts from one db and paste into another (again, as long as field names are the same).

Steve Brown

[tallboy755]

Thats what i thought i would hear ... if anyone has a better way please feel free to post it