Hey all,
i have a dB with 2 tables, one is for customers called customer view, the other to add additional info about the customer called rider Reg. I want to open the rider Reg form from the customer view form and display information for that customer - defined by the id from the customer record (rider Reg table has a customer if field), if there is not info already there to display, I want it to input the customers if into the customer I’d field in the rider Reg form. I can get one to work without the other but I can’t work out an if null method myself to get the following, search for customer I’d number and if null add it to the customer I’d field.
hope that makes sense