J
Jaybird
I thought I knew how to do this... I'm redesigning a non-normalized table
with a new index so that we can search through Orders by line item.
Previously, all orders had up to four line items. I used a union query to
break it out and added an index. Good so far. Now I'm redesigning the Order
Entry form that goes along with it and I've run into trouble. The new PK for
the main form is RecordID. What I did was create a subform based on the same
record source as the mainform and linked them by Order Number. This is
certainly a one to many relationship, and it displays existing records fine -
updatable and everything, but when I try to entry new records it won't let
me. I'm thinking that linking a recordsource to itself is problematic. The
normal set up is one table to another, Primary Key to Foreign Key. If that
is the issue, then I need to break up the main table into at least two. One
for the details of the main record, and another for the line items. Since
I'm hard-headed and thought I had a good idea, I'm reluctant to throw the
baby out with the bath water. Must I go ahead and break apart my main table,
or is there a way around this problem? If Allen Browne sees this post, he'll
be ashamed of me, since he tried to talk me out of all this some time back...
with a new index so that we can search through Orders by line item.
Previously, all orders had up to four line items. I used a union query to
break it out and added an index. Good so far. Now I'm redesigning the Order
Entry form that goes along with it and I've run into trouble. The new PK for
the main form is RecordID. What I did was create a subform based on the same
record source as the mainform and linked them by Order Number. This is
certainly a one to many relationship, and it displays existing records fine -
updatable and everything, but when I try to entry new records it won't let
me. I'm thinking that linking a recordsource to itself is problematic. The
normal set up is one table to another, Primary Key to Foreign Key. If that
is the issue, then I need to break up the main table into at least two. One
for the details of the main record, and another for the line items. Since
I'm hard-headed and thought I had a good idea, I'm reluctant to throw the
baby out with the bath water. Must I go ahead and break apart my main table,
or is there a way around this problem? If Allen Browne sees this post, he'll
be ashamed of me, since he tried to talk me out of all this some time back...