I'm an old hand at VBA and SQL but new to data macros. I have an Access 2010 web database with two tables, tblA and tblB, and two web forms, frmA and frmB.
On double click of a field in frmA I want to set a TempVar and use that to look up a record in tblA. If a record is found I want to navigate to form B (recsrc = tblA) and display that record, and if no record is found I want to navigate to frmB, create a record, and populate its fields with values looked up in tblB.
Do I use Look Up A Record In tblA to see if there is a record? How do I test to see if a record is found? Do I then use BrowseTo to navigate to frmB? If so, if there is a record do I display it by filtering on it in the form?
If somebody could outline the approach to take I'd appreciate it. In the client version of this functionality I had this working in 10 minutes with VBA and SQL. As it is, with Named macros I have spent two days running into one dead end after another.