W
WDSnews
When using an invoice form, it should be possible to look up all the line
item data and duplicate it into the detail table. but how?
I know how to build a combo box to reveal data from a related table, but I
don't know how to copy multiple fields from its record to a different record
of a different table. It should be possible to select an 'Apple' detail
item on the Invoice subform and let Access fill-in the line-item details,
including the description and price. Then it should be possible on the
Invoice's subform to manually change the price and description if desired.
I'm assuming three tables would be used: 'Invoice', 'Invoice Detail', and
'Items'. The 'Invoice Detail' is the child table of 'Invoice'. The 'Items'
table would hold all the lookup data for the 'Invoice Detail'. What do I
need to do in my tables and on my form to enable automatic data entry of
'Invoice Detail'?
item data and duplicate it into the detail table. but how?
I know how to build a combo box to reveal data from a related table, but I
don't know how to copy multiple fields from its record to a different record
of a different table. It should be possible to select an 'Apple' detail
item on the Invoice subform and let Access fill-in the line-item details,
including the description and price. Then it should be possible on the
Invoice's subform to manually change the price and description if desired.
I'm assuming three tables would be used: 'Invoice', 'Invoice Detail', and
'Items'. The 'Invoice Detail' is the child table of 'Invoice'. The 'Items'
table would hold all the lookup data for the 'Invoice Detail'. What do I
need to do in my tables and on my form to enable automatic data entry of
'Invoice Detail'?