Is this possible, and if so how?

I have a layout showing records from Table A which contains a portal to Table B. When a user types within this portal a related record in Table B is created.

What I want is for a record also to be created in Table C at the same time. Can this be done without the user having to do anything or do I have to provide a button/script to create a relationship to table C? (I'm struggling with this approach as well - with my limited knowledge I would have thought the Set Field function would be the way, but I can't seem to make this work properly)

Any advice appreciated.

Are you trying to use Set Field from a layout that does not contain the field? I have discovered in order to set field "X" to a value of "y" that you must navigate to the layout that has field "X", then go to field "X", then set field "X". This is a drag, but it appears to be the only way to use set field.

Thanks for your response. I've worked out that although I was going to the right layout/related record, I was asking the script to set a field in another Table occurrence. Had forgotten that layouts are linked to particular table occurrences.

When I got the script to work I was also using your thought about including a 'go to field' step before the 'set field' script set. I then tried it without the 'go to field' step, and it still works. I also have other scripts successfully using 'set field' without first 'going to the field', so its not essential to include it. (But obviously in other scripts doing other tasks it may well be a necessary step).

Hi Hociman

I am confused by your problem with the set field command as one of its strengths is the fact that you do not have to have the target field on the current layout in order to successfully use the set field script step - at least not previous to 8 you don't. I don't have 8 but I would be very surprised if they have taken a backward step on that one.

Phil

Help!

I think I have a similer problem, I am trying to get a list of years to disply (done that part) with the answer for that year in the next filed then the location for that event in the next and all this is within a portal.

I have attache the file as you will understand what I am trying to do better!

Please could you help me out?

YIM

livefeed05

help.zip

Edited January 7, 200620 yr by Guest