Access To Form Records for Query

Access To Form Records for Query

I don't know if this is possible, but I wanted to try and create a script so that on user edit on a field say product ID it will query all the current data and if it finds the same product ID it will auto populate the other fields.

This if fairly straight forward in an acess / sql environment. Something along the lines of

if forma.productID (in entry) = formB.productID then
forma.description = formb.description
etc...

Basically creating linked tables. But with the structure of creator I don't know how that would be achieved. And unfortunately I cannot create a static description form or something to that extent that I could link tables to because each "product ID" and the other fields related to this product ID are generated on input and vary each time.

Any suggestions would be appreciated. Thanks!