S
Sharon
Hi -
I designed a db following none of the rules I should have
followed. The logical sequence (or so I thought) was that
a user would enter data in Form #1 (40-1)which put data
into Table #1. On Form #2(Contracts) they would select
part of the data using a combo box that pulls info from
1st form (of which I updated Table #2 with the data from
Table #1 plus the new data entered by user). On Form #3
(Task Orders), they would select part of the data using
another combo box from the 2nd Form (of which I updated
Table #3 with data from Table #2 [and table #1]). I then
had Table #4 (Invoices). The relationship of the tables
were all One to Many (One Task Order to Many Invoices; One
Contract to Many Task Orders; One 40-1 to Many Contracts;
etc). NOW, I am told that there could be MANY 40-1s to
MANY Contracts. I'm at a loss to figure out how to make
that change & how to enable a use to pick an unlimited
amount of 40-1s per contract. Can someone maybe point me
in the right direction? I'm thinking somewhat of a
subform thing (Contracts form w/ 40-1s being a subform),
but can't figure out Table-wise how I can do this, since I
didn't follow the recommendations of not pulling data from
table to table.
Any help would certainly be seriously appreciated!!!
Thanks -
Sharon
I designed a db following none of the rules I should have
followed. The logical sequence (or so I thought) was that
a user would enter data in Form #1 (40-1)which put data
into Table #1. On Form #2(Contracts) they would select
part of the data using a combo box that pulls info from
1st form (of which I updated Table #2 with the data from
Table #1 plus the new data entered by user). On Form #3
(Task Orders), they would select part of the data using
another combo box from the 2nd Form (of which I updated
Table #3 with data from Table #2 [and table #1]). I then
had Table #4 (Invoices). The relationship of the tables
were all One to Many (One Task Order to Many Invoices; One
Contract to Many Task Orders; One 40-1 to Many Contracts;
etc). NOW, I am told that there could be MANY 40-1s to
MANY Contracts. I'm at a loss to figure out how to make
that change & how to enable a use to pick an unlimited
amount of 40-1s per contract. Can someone maybe point me
in the right direction? I'm thinking somewhat of a
subform thing (Contracts form w/ 40-1s being a subform),
but can't figure out Table-wise how I can do this, since I
didn't follow the recommendations of not pulling data from
table to table.
Any help would certainly be seriously appreciated!!!
Thanks -
Sharon