I imagine the answer is here somewhere, but gosh--what to query???
I have an existing database in use by a specific department to track
errors
made by individual employees. My department is tasked with entering the
employee info into this db, namely their employee name, id#, phone
extension,
etc. My department also uses the error tracking data entered by the other
department. However, we have additional fields we want to track and enter
at
the same time we set up their user info without using the existing table.
So, the long and short of it:
I have database X with table A containing fields: name, id, SSN, phone#
I want a form that will enter all of the above data into dbX table A
whilst
also entering the same name, id, SSN, and phone# into database Y table B
in
addition to fields: error, birthdate, etc. I have database x linked
into y
without a problem. I just need to be able to query my records across both
tables with a unique id and enter the data at the same time. Make
sense???
PROBABLY NOT. That's why I don't know where to search! :)
|
