Having trouble adding information to the second row of a
portal – seems to be a common thread but I haven’t found a solution.
Fields are inside the portal and are not touching the boundaries so nudging a
field here and there is not the solution. Setting up the proper relationship
seems to be the issue.
I use FileMaker for a small business, I designed the
database a long time ago and have just recently upgraded from 6 to 16 so I am
basically relearning everything all over. I had only one table before
basically without relationships except for Similar Names, which I think was created
on its own. So, I am learning as I go and trying to clean things up along
Here is what I have:
Customer Details Table
Contains lots of fields and many records
Sales Archive Table - I want to create a portal to record
each time a specific item is sold – only 1 record that contains the portal.
Maybe 7 fields total that are related to the Customer
Details Table/Layout (the related fields are located in a tab on this layout,
if that matters)
How is the relationship set up?
This was my initial approach:
Sales Archive Layout: Display records from Sales Archive
Portal: Show related records from “Customer Details
Table” – Tried this initially and I thought it was working until I noticed the
number of records matched the Customer details table so this is no good.
Relationship: ID = ID between the two tables?
Allow Creation of records in the “Sales Archive Table”
Do I use the “=” Cartesian operator? I tried the “X”
but then it doesn’t have the option to create records. I tried other fields
for the relationship (Date Sold for example) and none of them seem to work
Please help and If you need more specifics please let me know. Thanks.