Portal and auto enter value list field

[Kicker3]

I've attached a file I'm wanting to have the name field copy itself to a ShedNameFile field at top of layout, and that works like I want it to,but my problem is I also want it to go to Rent Due field to the value list.. all by clicking the Name field. Is this possible? I cant figure it out.

Thanks for the help

StorageSheds.zip

[Søren Dyhr]

Replace the scriptsteps in your portaline buttons with:

Set Field [ Sheds::ShedNumberField; Customers::Name ]

Go to Field [ Customers::RentDue ]

...Please note that developers of database systems, can't get away with deleting what the user might temporarily have stored in his clipboard so stop using copy/paste in scripts!

But why do you need to redundantly store customers name in both tables, honestly isn't this more than one table selfjoined ...where you go to each record via a GTRR and a scriptparameter that tells which portalrow the call was made from if the rent due really should be altered in the portal???

--sd

[aaa]

I repaired your script as suggests Souren Dyhr! It did what you want!

StorageShedsCopy.zip

[Kicker3]

Thanks for the advice Souren Dyhr. I need all the advice I can get. I had it in a 1 table solution, but then I changed it to 2.. mostly to keep additional info on customers like address, extra phone # and some personal notes about each one.

Thanks aaa for applying it to my solution.

[Søren Dyhr]

mostly to keep additional info on customers like address, extra phone # and some personal notes about each one.

Thats an entire different matter ...if what you need, is a dynamic feature for field labels, not quite knowing how many and which each record needs - This might be high octane for a novice but be somethign to return to when you get the hang of relational designs:

http://previews.filemakermagazine.com/videos/513/DataTagging_full.mov

--sd