Here is what I am trying to accomplish and have been stumped so far. I ave set up a bill to db, ship to db and zip db. In a form view I have all the fields I desire from bill to on the left side and all the fields from ship to on the right. I wish to create a new record in both db's when using a single button to create new record.
If cust_num is in bill to I want the info placed in the fields accordingly. If cust_num is new I fill in bill to data. Many ship to's can go with a single bill to so I need the ability to fill in ship to info on the form regardless but if a duplicate to a record in ship to then just quietly delete the entry.
Now to the zip db. When finished entering the zip in either zip field I want Approach to search the zip db and locate the correct city and state and then fill the appropriate fields with the data.
Any help with this dliema would be greatly appreciated.
If cust_num is in bill to I want the info placed in the fields accordingly. If cust_num is new I fill in bill to data. Many ship to's can go with a single bill to so I need the ability to fill in ship to info on the form regardless but if a duplicate to a record in ship to then just quietly delete the entry.
Now to the zip db. When finished entering the zip in either zip field I want Approach to search the zip db and locate the correct city and state and then fill the appropriate fields with the data.
Any help with this dliema would be greatly appreciated.