I've re-pointed all relationships, I can double click on the table within
the graph and it comes up correct, but when I go to field definition, the
fields that have lookups are all missing the lookup values, I have 3 other
relationships to that table, when I select a field definition, select a
lookup value, the only choices I have for a starting table are the other
relationships, not the actual table

Best Regards,
Dan Kelly
Yachtlink Engineering Inc.
1 954 663 1630


-----Original Message-----
From: FileMaker Pro Discussions [mailto:[log in to unmask]] On
Behalf Of BEVERLY VOTH
Sent: September 03, 2012 13:09
To: [log in to unmask]
Subject: Re: Moving tables

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.