Any advice on the following form query would be much appreciated.
My database contains the following:
TBLsupplierorders
QRYsupplierorders
FRMsupplierorder (continuous form)
TBLsupplierorders contains details of orders we place on behalf of our client (supplier quote date and value, invoice date and value etc). At the end of each record is the 'Invoice/Journal to finance' field. in this field we currently input the amount to be invoiced to the client, usually the same as the supplier invoice value. However sometimes on large invoices, we need to issue a part-invoice to the client (e.g. £50k of a £200k supplier order).
The way we record this is by using copious notes in the comments field to record amounts and dates. Far from ideal.
I would like to be able to record multiple 'invoice/journal to finance' records for each supplier order. That way I could accurately record the amount, date and any comments related to that particular part-invoice as well as seeing how much is left to invoice to the client and producing an accurate invoice report.
I would normally do this with a subform but Access 2010 will not allow me to add a subform to a continuous form. FRMsupplierorders needs to be a continuous form for ease of updating.
I've attached the part of the database I'm referring to, in the hope that someone can advise me because I'm stumped.
I have no knowlege of VB and stumple along blindly with SQL.
Many thanks in advance
Allison
My database contains the following:
TBLsupplierorders
QRYsupplierorders
FRMsupplierorder (continuous form)
TBLsupplierorders contains details of orders we place on behalf of our client (supplier quote date and value, invoice date and value etc). At the end of each record is the 'Invoice/Journal to finance' field. in this field we currently input the amount to be invoiced to the client, usually the same as the supplier invoice value. However sometimes on large invoices, we need to issue a part-invoice to the client (e.g. £50k of a £200k supplier order).
The way we record this is by using copious notes in the comments field to record amounts and dates. Far from ideal.
I would like to be able to record multiple 'invoice/journal to finance' records for each supplier order. That way I could accurately record the amount, date and any comments related to that particular part-invoice as well as seeing how much is left to invoice to the client and producing an accurate invoice report.
I would normally do this with a subform but Access 2010 will not allow me to add a subform to a continuous form. FRMsupplierorders needs to be a continuous form for ease of updating.
I've attached the part of the database I'm referring to, in the hope that someone can advise me because I'm stumped.
I have no knowlege of VB and stumple along blindly with SQL.
Many thanks in advance
Allison