Newbies jam Posted August 10, 2005 Newbies Posted August 10, 2005 Is there a way to copy/remove a table (and all its fields) from one file to another existing file? Of course it is possible to duplicate one file and delete all the tables one does not want, but this does not work if you have two files and you want to move one table from one to the other.
PeterHW Posted August 10, 2005 Posted August 10, 2005 Unfortunately this is not possible, unless you use a third party tool like FMRobot. Regards, Peter
Lee Smith Posted August 10, 2005 Posted August 10, 2005 You can do it the old fashion way, Copy/Paste. Lee
Newbies jam Posted August 10, 2005 Author Newbies Posted August 10, 2005 You can do it the old fashion way, Copy/Paste. Lee How? We've tried with no luck! Maybe it works on a Mac, but unfortunately we only have PC's in the office ;)
Lee Smith Posted August 10, 2005 Posted August 10, 2005 You should update your profile to reflect the OS, Platform, and version of FileMaker. And you are trying this in Layout mode for both files (layouts).
PeterHW Posted August 11, 2005 Posted August 11, 2005 Lee, maybe I misunderstand you but surely you cannot copy tables between files using copy/paste ? Layouts, OK, but I haven't been able to bring a complete table with fields into another file. Peter
Lee Smith Posted August 11, 2005 Posted August 11, 2005 It was a little ambiguous the way I said it. You're right, it will not move the fields from one File to another, only their attributes. However, if you create the Fields in the second file prior to the copy/paste (exact same names are required), then the fields will appear just as they were in the first file . If the fields don't exist, then their attributes appear as blank fields, although the Field Names appear as they did in the first file. You can manually select the fields and change a blank field by selecting a Field that does exist. HTH Lee
PeterHW Posted August 11, 2005 Posted August 11, 2005 Thanks for clearing that up. But I think the original question was whether it is possible to import an entire table - with fields and possibly records - from one file into another. And that, unfortunately, is not the case. It *should* be possible IMHO, as well as table duplication within the same file, but it seems we will have to wait until Version 8 (or longer) to get that functionality. Regards, Peter
Lee Smith Posted August 11, 2005 Posted August 11, 2005 Don't feel too bad, I've been waiting since version 1. I guess that's why we get paid to do this, if It it was easy, they wouldn't need us. Lee
Recommended Posts
This topic is 7391 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 accountSign in
Already have an account? Sign in here.
Sign In Now