Access Subforms - Master/Child fields - one-to-many relationship

  • Thread starter Thread starter SueB
  • Start date Start date
S

SueB

Having some difficulty. I have a Master form, embedded with a subform, which
itself is also embedded with another subform. The Master form is intended to
have one master record, but it needs to be able to accept multiple subform
data and multiple subform subform data. So, A can have (1) to (4)
sub-entries, and each of those 1 to 4 sub-entries should be able to accept
(i) to (iv) sub-entries.

I seem to be able to get A with multiple (1) to (4)s, but cannot enter
multiple (i) to (iv) for the 1 through 4s. When I go into relationships, I
cannot seem to get a one-to-many relationship, and my error message when I
try to enter multiple (i) to (iv)s is:
"The changes your requested to the table were not successful because they
would create duplicate values in the index, primary key, or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try again."

Now, with the Master/Child fields in Properties, I have the following.

1. With the one that works (the first subform in the master), the ID (Key)
shows up as the Link Master Field twice with nothing in the Link Child Field.


2. For the one that doesn't work (sub within a sub), the Master is the first
sub ID and the Child is the sub within a sub ID.

I do NOT have a reference book at the moment (expect one today), and the
internal Help menu isn't helping me.
 
Having some difficulty. I have a Master form, embedded with a subform, which
itself is also embedded with another subform. The Master form is intended to
have one master record, but it needs to be able to accept multiple subform
data and multiple subform subform data. So, A can have (1) to (4)
sub-entries, and each of those 1 to 4 sub-entries should be able to accept
(i) to (iv) sub-entries.
Click to expand...

If I understand what you are describing, then this is fairly routine. It can all be handled using
Link Child/Link Master Fields of the subforms.

You have a main form. Embedded in this main form as a subform is another mainform which has an
enbedded subform.

The main form will be a single form. The embedded "Main Form" will be a single form. Its subform
can be a continuous form.

Probably the best thing to do is to disclose the structure of the tables involved along with the
keys and relationships.
 
Back
Top