If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can't create new records
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 |
#2
|
|||
|
|||
can't create new records
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 ViewSQL). -- Good Luck :-) Graham Mandeno [Access MVP] Auckland, New Zealand "TBA" wrote in message ... 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 |
#3
|
|||
|
|||
can't create new records
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. "TBA" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|