Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Copying Fields and Value Lists to Another Database


This topic is 7518 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I use value lists mostly to have consistent input in various fields. (as choice lists in other words). I have two identical databases, both with the very same set of vlaue lists. When I copy a field to the 2nd database, the link to a particular value list does not stay with the field.

.

Is there a way to copy both the field and its associated value list to the target database... so that accessing the field brings up the same choice list as in the first database?? confused.gif[email protected]

FileMaker Version: 6

Platform: Windows 2000

Posted

I just copied two fields formatted as a checkbox and menu to a copy of the db with no problems. Can you provide more detail to your problem?

Posted

Try copying a field formatted as a POP-UP LIST...

.

One field that I try to copy from one database to a 2nd identical database and NOT lose the attached value list is a field formatted as a POP-UP LIST based on a 3rd database that contains only the values for the value list. [like using a table of values in MicroSoft Access] (Is this gibbersih yet???) I go to layout mode, select the field to copy, chose copy then go to the 2nd database and choose paste....is there more to it than that? Then, in Browse mode, when I choose the field it no longer acts as a pop-up list.

.

THANKS for yoiur help!

Posted

Where is the 3rd database located in relation to the copy? If it's in a different folder, that's probably your issue. If you format the field in Layout Mode, it will probably show 'pop-up list using value list <unknown>'.

Posted

All THREE databases are in the same folder. I learned that lesson the hard way a long time ago.

.

Just a shot in the dark....could it make a difference HOW I copied the database in the first place?:)

I right clicked and chose copy, clicked on the desktop, then right clicked and chose paste. Pretty straight forward.

.

Thanks for your continued effort to help!!!

Posted

Hm, I tried copying/pasting the file with no problems.

How is the field formatted in the copy?

Posted

I am sorry. The files are at work and I don't remember how the fields are formatted without looking.

I'll try to look tomorrow.

.

Again, thanks a bunch.

.

PS - unrelated question: The official FileMaker site used to have a list of all the recognizable corporations, educaitonal institutions, etc.

that used FileMaker in some respect. Any clues where I might find such a list?:) I work for a major educatinal institution and BIll Gates

has made MS Access the "preferred" database here. (Well, of course, by buying his way in!! It certainly is NOT because of a superior

product!!)

FileMaker Version: 6

Platform: Windows 2000

Posted

It sounds to me your field isn't formatted as "popup-list" in the file you're copying to.

As for the company links, it appears they have been split out into areas (education, non-profit, etc).

If you go the the "K-12" or "Higher education" areas and select "customer stories" you get the page:

http://www.filemaker.com/customers/stories/K.html

http://www.filemaker.com/customers/stories/Higher.html

...

Large corporations are here:

http://www.filemaker.com/customers/stories/Medium-Large.html

This topic is 7518 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.