I'll help, but why on God's green Earth would you want to do something
as inefficient as this? You're opening yourself up to corruption and
file-locking nightmares, among other things.
Well, perhaps it is inefficient. I have a database with a form that
asks if timber sales tasks are completed and records the answers (among
other things) in a table. One of the tasks is to enter a before and
after photo into a photo database that keeps track of the photo history
for forestry lots. If the user says "yes", that the photos have been
taken, I'd like to open a new record in the photo database so that they
can enter those photos.
Instead of going back and forth between databases, why not just link to
the photo database and open a form in the database you're in? Then the
data will appear in both places, without the overhead or confusion of
jumping between databases.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
