I thought I was making progress

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

Guest

but I'm really going nowhere fast.

I have followed the advice of many here that offered solutions.

I now have a main table (tblEpistry) and 4 unit tables (tblUnit1 through
tlbUnit4)

The main data entry form has the qry_data_entry as the record source and the
query has all five tables in it, linked by tblEpistry.EpistryID to EpistryID
in each unit table.

When I try to open my main form, I get 'Can't go to specified record' and
when I debug it, it is hanging on my Me.EpistryNumber.Setfocus line.

I simply want to use this form to enter data into my five tables. Any ideas
what I am doing wrong?

Thanks in advance.
 
Paul,

The simple answer to the question of what are you doing wrong, is trying
to use a single form to enter data into 5 tables at once.

Can you please explain the 4 Unit tables, what are the similarities and
differences between them, and what is the nature of their relationship
with the tblEpistry table? On the face of what you have told us here,
it looks like you need to take a step back, and review your tables and
data structure before working further with your forms.
 
Hi Steve,

You are probably right, I'm sure my lack of experience is the problem is
designing this project. In a nutshell;

I have a registry for Cardiac Arrest and Major Trauma Outcomes. There are
several areas for which we collect data, Patient Information, Response
Information (incident location, type), Ambulance Information ( the 4 units),
Hospital Information, and First Responder Information.

The make the data entry process easier, I wanted a single form for the data
entry.

I initially built only 2 tables due to the type of reports that were
requested, 1 for the units and 1 for everything else. Then, due to a change
in the reports requested, I had to break the unit table into 4 tables. This
was suggested here from a previous post of mine to normalize the data.

There are other tables to hold lists such as Hospitals, Paramedics, First
Responders etc. There are no reports being generated from these tables.

In total, there are 87 fields on the form, 11 for each unit (44 total).

Any advice would be appreciated.
 
Disregard my post, I figured it out. My PC crashed and some changes I made
did not get saved. Everything is working fine now.
 
Paul,

I am happy to know that you have this working for you now.

However, I will still comment on a couple of points in your post - see
below...

The make the data entry process easier, I wanted a single form for the data
entry.

I initially built only 2 tables due to the type of reports that were
requested
Click to expand...

It is generally imortant to follow the principle that the table design
is dictated by the nature of the data being managed. Operational
questions such as form and report functionality should not come into the
equation at this stage.
... I had to break the unit table into 4 tables. This
was suggested here from a previous post of mine to normalize the data.
Click to expand...

Normailizing un-normailised data usually progresses in the opposite
direction, i.e. combining disparate tables into one. In your example, I
would suspect you have un-normailised your data (and made life more
difficult for yourself in the process).
 
Back
Top