November 8, 200619 yr So, I have a moderately complex database I'm working on which uses record IDs for pretty much all the tables. But the users get to dynamically build a lot of the relationship records via portals. I've done a lot of these in FM over the years, and now I'm trying to figure out the best way to do this requiring the fewest fields & relationships. This sample database has a simplified version of the type of relationship I have to use in many places. The trick is that I'd like to hide the ID numbers from the user (they're meaningless to them) and allow the user to build the relationships through the portal (via a popup), based on the name. In the past I've handled this different ways: - Show both the ID and name fields. Had the popup contain ID + Name, but only kept the ID. - Used a separate global 'set' popup, along with an 'add' button to fire a script which created the index record in a more manual fashion. Since I think this type of thing comes up for a lot of people, I'm wondering what the slickest way to do it is. Suggestions? ProjectsProducts.fp7.zip
Create an account or sign in to comment