Using a Query to enter data as well

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am trying to input data into one data table that is
linked to another table in another database. I want the
data I enter to show up in their table. Then they can
search for the data by using a dialouge box ( a select
query), pull up the data I have entered add to it print
a "job ticket" . The only other thing is what they add to
it does not need to then be added to my database.

So it starts on my table goes to their table they perform
a select query to find the right info from all the info
(about 1,000 records) I have entered, then they add to
this info and print a ticket. The info they add is saved
in their table only. Is this possible?
 
Yes, as long as you use all the fields to input your data from their table
in your query. Having said this, you would be better off creating a form in
your database that uses the linked table from the other database.
I would be best also if the other database resides on a server and not a
user's machine that is shared. This will surely cause you some corruption
problems and maybe to the point of permanent loss. All databases that are
going to be shared among multiple users should be split. Master db with
tables only on server (backend) and the front-end should contain linked
tables, queries, forms etc. on each user's machine. This is the recommended
network sharing scenario from Microsoft.
 
Back
Top