can't create new records

[TBA]

Hi all.
I have created a simple database to enter data from paper-based forms.
In general terms each patient has a unique identifier - an 'NHI' number.
in the detail section the NHI along with another ID field appears above a
series of tabbed pages to enter all the data. In this way I always have the
NHI visible above the data I am entering.
the form recxord source for each tabbed page has the patient table (with the
NHI primary key) linked to other tables used in that particluar page.
Relationship-wise, tblPatient contains the Primary key 'NHI' and all other
tables have a link to their own 'NHI' identifier as a one to many
relationship (the one being at the primary key end).
Unfoftunately I cannot create a new record, or if I enter a new NHI into
tblpatient it is not visible in the forms created.
Not sure how to adequately describe the situation, so ifg anyone wants to
have a go at suggesting further detail or a magic solution that would be
great!!!
-is there anyway of showing people what i mean?
cheer, Theo

 

[Graham Mandeno]

Hi Theo

What is the RecordSource of your main form? Is it tblPatient, or is it a
query derived from tblPatient and one or more other related tables?

If it is a multi-table query, then I suspect it includes a field from a
related table which does not yet have a record with a matching foreign key
(NHI).

Can you please post back with the RecordSource of the form. If the
RecordSource is a named query, then include the SQL for that query (open the
query in design view and then click on View>SQL).

 

[Jame]

In design view of your form, right click on each subform and choose
properties. Make sure that the relationship is connecting to correct fields
and that none of the forms are pulling data from a query.