A 1 to 1 relationship is unusual, as there can be only one child record for
each parent record. A search for subclass or subclassing should produce some
more information Without knowing anything about how your database is put
together or what it is used for it is almost impossible to offer specific
suggestions. In general you do not assemble several tables into a single
query for data entry purposes. For one thing, such queries are often read-
only. In other cases (such as yours) there may be data integrity issues that
cannot be resolved.
As a point of terminology, "master database" is not especially meaningful. I
assume you mean the main table. If so, you are correct that you need a
parent record before you can have a child (related) record. However, it is
incorrect that "the inegrity check will create the record in the child
{tables}". The integrity check is just that: a check. It does not by itself
perform actions. For adding child records, a form/subform is the typical
route.
A better understanding of databases in general and Access in particular may
be of value:
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/
A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html
A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
atledreier wrote:
I have a few tables in my database, all 1 to 1 with the master table.
I have a query that gather much of the data into one large
datasheet.The problem is I cannot add records through this query.
I get a message that I need a related record in the child table for it
to work.
Am I right in assuming I need to add the record in the master database
first, then the inegrity check will create the record inthe child
databases, and THEN I can add data through my datasheet?
--
Message posted via
http://www.accessmonster.com