In FMpro 5.5 I had two files, linked by a relation 'adresID'. Once I had
entered a city (and hence created a adresID), I could enter data in a
related record in a portal using a relation based upon adresID. Tabbing
into the portal just worked, a related record was created, obtaining
'magically' the same adresID.
In FMPro 7 however, using a similar technique, I wanted to relate
pricing in shop X, based upon productID, to a product in the product
database having the same productID. Now, however, I have two databases
(tables) in one file, and I am not able to tab into the related record,
obtaining 'magically' the productID in the other table.
How to do this?

ard

In article <1gm5ykm.1d7q5lqxoowt6N%ardpuntjonkeratxs4allpuntnl@b.c>,
 ardpuntjonkeratxs4allpuntnl@b.c (ard) wrote:

> In FMpro 5.5 I had two files, linked by a relation 'adresID'. Once I had
> entered a city (and hence created a adresID), I could enter data in a
> related record in a portal using a relation based upon adresID. Tabbing
> into the portal just worked, a related record was created, obtaining
> 'magically' the same adresID.
> In FMPro 7 however, using a similar technique, I wanted to relate
> pricing in shop X, based upon productID, to a product in the product
> database having the same productID. Now, however, I have two databases
> (tables) in one file, and I am not able to tab into the related record,
> obtaining 'magically' the productID in the other table.
> How to do this?
> 
> ard

Do you have the option to "Allow creation of records in this table via 
this relationship" checked under the related file in the Edit 
Relationship dialog box? This needs to be checked in order to allow you 
to create records via a portal.

To get the Edit Relationship dialog box, double click on the 
relationship box in the Define Database>>Relationship diagram. The 
relationship box is the little box on the relationship line that 
connects the two table occurrences in the diagram.

In FMP 7, relationships are inherently bi-directional, and any options 
for either side of the relationship are selected via the the Edit 
Relationship dialog box.

In earlier versions, relationships were always one-directional, defined 
from the Master file to the Related file. Further, the definitions were 
always text, not a diagram, and the options to be selected for that 
relationship were right in the Define Relationship dialog box.

So you use a different method in FMP 7 to set up relationships. This is 
a small price to pay for the enormous gain in clarity, flexibility and 
power available in FMP 7.

Bill

-- 
To send e-mail, remove .invalid

B Collins <bbcollins@earthlink.net.invlaid> wrote:

> To get the Edit Relationship dialog box, double click on the 
> relationship box in the Define Database>>Relationship diagram. The 
> relationship box is the little box on the relationship line that 
> connects the two table occurrences in the diagram.

That was the trap door I could not find. The 'help' function wasn't that
helpful, you helped me out. Thanks!

ard