C
CW
I have built a system for a depatch company that is to capture inquiries,
handle the calculation and storing of quotations, track the key dates in the
shipping process, store all the weights and quantities, allow sales invoices
to be produced and passed to an accounting system, and provide a job-costing
record. Oh, and produce all the necesssary documentation.
It consists of about 20 tables in total, some of which are simply for
"inquiry types" and "status" and static things like that.
There is a main table for inquiries, another for materials and crates to be
used, one for costing and quotes, another for events, another for weights,
another for invoices.
The "main" form is based on the inquiries table and that works fine. Any
data that is entered on the form gets to the table and is retrievable via
queries, or into merge docs, etc.
Then I have five tabbed pages hanging off this, onto each of which I have
placed a subform - one for the materials and crates, one for the quotes, etc
etc as per the tables mentioned above.
I use one unique Job Ref that is stored on the Inquiries table/Main form and
this is also on each of the subforms, forming the link to the same job no
matter which tabbed page/subform I am in.
I have also used this for the relationships between each of the tables i.e.
Inquiries to Quotes, to Materials, to Events - all are based on the Ref field
and all are set to join type (1).
Everything seemed to be going along pretty well until I started trying to
test the data storage and interaction between the several "parts" of a job
record.
My huge problem is that when data is entered on any of the subforms it does
not store in the respective underlying table and hence (obviously) is not
retrievable either for viewing or for use in the docs.
Something is obviously radical wrong in the structure. In some fields as
soon as I open a subform and try to enter anything I get a msge saying that a
value cannot be assigned to this object (with 3 possible suggested causes,
none of which is actually the case so far as I can see).
I realise it is quite difficult to assess where the problem lies but in
principle am I OK doing things like this - with subforms sitting on top of
the various tables, hanging off tabbed pages attached to the Main form.
How do I get data to store??? It's pretty fundamental for a database, is it
not!!!
Your anticipated help is much appreciated, thanks
CW
handle the calculation and storing of quotations, track the key dates in the
shipping process, store all the weights and quantities, allow sales invoices
to be produced and passed to an accounting system, and provide a job-costing
record. Oh, and produce all the necesssary documentation.
It consists of about 20 tables in total, some of which are simply for
"inquiry types" and "status" and static things like that.
There is a main table for inquiries, another for materials and crates to be
used, one for costing and quotes, another for events, another for weights,
another for invoices.
The "main" form is based on the inquiries table and that works fine. Any
data that is entered on the form gets to the table and is retrievable via
queries, or into merge docs, etc.
Then I have five tabbed pages hanging off this, onto each of which I have
placed a subform - one for the materials and crates, one for the quotes, etc
etc as per the tables mentioned above.
I use one unique Job Ref that is stored on the Inquiries table/Main form and
this is also on each of the subforms, forming the link to the same job no
matter which tabbed page/subform I am in.
I have also used this for the relationships between each of the tables i.e.
Inquiries to Quotes, to Materials, to Events - all are based on the Ref field
and all are set to join type (1).
Everything seemed to be going along pretty well until I started trying to
test the data storage and interaction between the several "parts" of a job
record.
My huge problem is that when data is entered on any of the subforms it does
not store in the respective underlying table and hence (obviously) is not
retrievable either for viewing or for use in the docs.
Something is obviously radical wrong in the structure. In some fields as
soon as I open a subform and try to enter anything I get a msge saying that a
value cannot be assigned to this object (with 3 possible suggested causes,
none of which is actually the case so far as I can see).
I realise it is quite difficult to assess where the problem lies but in
principle am I OK doing things like this - with subforms sitting on top of
the various tables, hanging off tabbed pages attached to the Main form.
How do I get data to store??? It's pretty fundamental for a database, is it
not!!!
Your anticipated help is much appreciated, thanks
CW