Hi All,
Apologies for the lack of scripting ability. I’m hoping to get started if someone can point me in the right direction.
I have 2 tables TableA has records in with following ID, Rate
TableB has the same ID, Rate
I want to build a script that, w...
Thanks Stephen, I really appreciate the time you have taken to explain.
I probably could do it with a linked table but it is more complicated than that as it’s more selective as to which records should update.
I am keen to learn the scripting as I th...
Thanks. I don’t think it needs to be that complicated. I use the batch block at the moment but thought it would be easier in scripting. I’m not familiar with java script but it would simply be an update statement in SQL where the ID = the ID specifie...
Hi,
Thanks for the reply.
TableA holds a cost (Rate) that is the cost for a day.
TableB holds the bookings based on that Rate.
If the rate changes for a person (ID) then I want to update the rate manually in TableA and then run a script that updates ...
Thanks Bill. I can’t find anything that does the same as I’m requesting, although I guess it’s a common thing to do. I will try and work it out but will take advantage of your request form in the meantime.
