View Single Post
  #8  
Old July 6th, 2009, 12:50 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default One table or Two?

On Fri, 3 Jul 2009 08:13:01 -0700, DUNNER7
wrote:

Thanks, you take me back to my original question. If I am able to do this
with one table (infractions/dispositions) together.... can two seperate
people, 1: the reporer of the incident and, 2: the person who handles the
disposition enter data into the same table using two different forms.


Access is multiuser, out of the box. Two users can use the same database,
concurrently or separately.

One Table can be referenced by two (or twenty) separate forms.

So... Yes.


For
example I would design form that would enter specifics of the
infaction...form would be sent to admin (disposition part), person could view
infraction, hit command button, pull up form to enter disposition, hit enter,
and disposition information is entered onto same row as infraction
information in the fields set aside for disposition data in one table??


Yes.

It would be nice to be able to flogg a child every once in awhile.


Well, not *really* but... I know the feeling!

--

John W. Vinson [MVP]