posting information on more than one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB for client information in a clinic. All appointments get posted
to an Event DB, as well as to either a NewInfo DB, an Apointment DB or one of
several others. Is there a way to bring up a form, such as NewInfo and have
a button that posts select info, such as date and client number to the Event
DB?
 
While it is entirely possible to execute code which inserts/updates
records across multiple tables, before we get to that point I need to
ask WHY do you need to do this? It sounds as if you're duplicating data
which is a huge no,no in database design. *What* specific information is
contained in the various DB's? Also, are you using multiple *.mdb files
(ex event.mdb, newinfo.mdb, appointment.mdb) or using multiple tables?
There is a distinct difference between the two.
 
I am using multiple tables within one MDB. The data between tables is not
the same, with the exception of indexes. The Event DB (I should have
identified that as the Event table in my original post) contains event
number, date, clinician identifier, and client identifier. NewInfo contains
a client identifier, the Event identifier and clinical information.
Appointment contains the Event identifier and appointment information.
What I wanted to do is have a form for NewInfo that when posted would also
generate the Event data. I am open to other ideas and yes, this is
definitely not my day job. I know just enough about databaes to get in
trouble.
 
Is there a way to bring up a form, such as NewInfo and have
a button that posts select info, such as date and client number to the
Event DB?
Click to expand...

Trap the cmdOK_Click event. Just create an INSERT command with the
appropriate VALUES and use db.Execute to run it...

Hope that helps


Tim F
 
So it sounds like you need to explode a record taking bits and pieces
and putting in various locations. Use a main form/subform setup where
the common information is entered into the main form and then the
differences go into one or more subforms. You would then use code to
control which subform is displayed to capture the additional information.
 
Back
Top