Dan, You can "repoint" an occurrence on the Relationship Graph. Do so, by double clicking the image on the graph. Keep in mind that other things may or may not work after doing that... :)

Beverly

On 03 Sep 2012, at 12:51 PM, Dan Kelly wrote:

> I have a maintenance database file with many tables, some of them tables have a relationship to another file which is also another type of maintenance, I imported the table into the file with multiple occurrences, after which when I go to the field definitions and view one of the fields that have a lookup, that lookup has been lost, when I try to reset it and choose the starting table I only get the earlier references that were in the file, I do not get the table I just imported, which is the table I am editing, I’ve run into this at time and can’t recall if I figured out why or want I did wrong, but deleting the prior relationships will allow the new table to show as a starting table, then I can recreate the old relationship, FMP 11 Advanced
>  
> Best Regards,
> Dan Kelly
> Yachtlink Engineering Inc.
> 1 954 663 1630
>  
> From: FileMaker Pro Discussions [mailto:[log in to unmask]] On Behalf Of Richard S. Russell
> Sent: September 03, 2012 12:17
> To: [log in to unmask]
> Subject: Re: Moving tables
>  
>  
> On 2012 Sep 3, at 9:52, Dan Kelly wrote:
> 
> 
> When I migrate a table from one file to another the default tables
> occurrence changes and the lookups change it there is already a relationship
> to that table with the new current file, when I go to reset the lookups then
> the current table which I had imported is not one of the options for
> default, can anyone tell me the best way to prevent this error when doing
> this?
>  
>  
> A request to Dan — and anybody in the future who asks a question — is to please mention which version of FileMaker Pro you're using, whether it's regular FMP or FMP Advanced, and what platform (Mac or Windows) you're operating on. The answers to your questions may differ depending on the context.
>  
> Also, in order to aid in communication, it helps if you can be as specific as possible. For example, not merely "I'm trying to migrate a table from one file to another" but rather "I'm trying to import the 'Addresses' table from the 'Programs' file to the 'Members' file." This too enables the response to be in terms most likely to be useful to you.