Search the Community
Showing results for tags 'Filemaker 16'.
Found 1 result
I have an auction calendar (layout - "Calendar") with properties that display address, date, time and location data on it from the PROPERTY table. When users log in and enter the layout, they see the calendar for the current day. These properties are common for everyone, and have a unique "PropertyID". I have two additional tables with key ID fields - the first is a USERS table with basic info about the user including their "UserID". The second is the USERPROPDATA table with a "UserID" field and "PropertyID" field. What I'm trying to accomplish is to allow the USERS to add their own pricing data (that only they can see) into a couple of fields from the USERPROPDATA table (Fields are "UserPrice1" and "UserPrice2"), but I'd like them to be able to do this via the "Calendar" layout. Again, this layout displays data from the PROPERTY table. Because I'm fuzzy on creating effective relationships (I'm new), I'm not exactly sure of the best way to do this. In the "Calendar" layout, I have a portal to the USERPROPDATA table displaying the "UserPrice1" and "UserPrice2" fields. When a user enters data in the portal, a record is created in the USERPROPDATA table with the UserID, PropertyID and the data from UserPrice1 and UserPrice2 in it. The problem is - everyone can see that data. I'm getting stuck on how to show only the logged in users' data for those properties. Any help is greatly appreciated. Thank you in advance.