Hi all,
I am trying to save a few key strokes. I want to add new rows from a table in a foreign database to my currently open database. My syntax is...
APPEND patinfo_dup TO patinfo WHERE patnumbr NOT IN (SEL patnumbr FROM patinfo)
The code works fine, but each time I do it, I get a pop screen called R:BASE Connect. I think it wants me to enter the USER ID for Data Source: and Password for Data Source:
Instead, I just click the OK button (I don't enter any thing in the 2 empty boxes) and the program advances normally. What can I do to prevent this pop up screen from showing up?
Mike
