djc728 Posted August 10, 2007 Share Posted August 10, 2007 David Kachel in his White Papers (which are quite good I might add) has a technique for editting portal records outside of doing it in the portal by "create an additional relationship to the table in question. Make it a one-to-one relationship using a global field as the Primary key and the existing ID of the related record as the foreign key. Put fields from that relationship on a platform on the layout along with a New Record button. Attach this button to a script that creates a new record in the related table, grabs the ID number of the new record and inserts it into the new global primary key field. Also, put a button over the portal row that sets the global primary key field to that records ID number, so that existing portal records may be edited in the fields on the platform. You'll have to make certain your scripts empty this global field when you change records in the primary table. This is only a few minutes extra work and makes for a far more professional looking interface." I like this idea and was wondering if someone has a simple sample database I could see implementing this technique. Thanks. Link to comment Share on other sites More sharing options...
Ender Posted August 10, 2007 Share Posted August 10, 2007 Maybe you should try it, and let us know if you get stuck. Link to comment Share on other sites More sharing options...
djc728 Posted August 10, 2007 Author Share Posted August 10, 2007 Your right and I did -- I had the relationship drawn to the wrong field. Its always a head banger. I'm cursing as we speak. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6238 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now