S
skulmat
I have created amodified northwind database to make calculations and keep
track of orders. The problem is as follows, i want to create a new section on
the order form allowing me to input adjustments (deposit allreasdy paid
etc..) so what i tired doing was creating a new subform to keep track of
this. but some problems have arose
1) When i try to print up an invoice, it pulls it in from a query, but now
there are duplicates of every entry on the order (one for every adjustment i
made)
2) on the inovice report i tried to tell it to display the adjustments(by
adding those fields into the wuery(which is the record scourece for the
report), but it is coming up as "?error".
I cant have the adjustments being stored in the regular products table for
multiple reasons.
Any help on this would be most appreciative.
thankx
track of orders. The problem is as follows, i want to create a new section on
the order form allowing me to input adjustments (deposit allreasdy paid
etc..) so what i tired doing was creating a new subform to keep track of
this. but some problems have arose
1) When i try to print up an invoice, it pulls it in from a query, but now
there are duplicates of every entry on the order (one for every adjustment i
made)
2) on the inovice report i tried to tell it to display the adjustments(by
adding those fields into the wuery(which is the record scourece for the
report), but it is coming up as "?error".
I cant have the adjustments being stored in the regular products table for
multiple reasons.
Any help on this would be most appreciative.
thankx