P
Pete
I have a master/detail form/subform based on tables for Purchase Orders
(master) and their order lines (detail).
I have a table for 'Categories' (around 30) which can be selected for each
PO line (detail).
I am displaying an additional field in the detail section so that users can
assign a vehicle to that PO line when the user selects either 'Vehicle -
Purchase', 'Vehicle - Maint. Repair' or 'Vehicle - Project Repair' from the
'Categories' drop-down for each PO line. I have a master table with vehicle
details.
I could just add an additional field to the detail table (PO order lines),
but that would mean all records with a category other than those above would
have a field for a vehicle ID which would not be relevant, and would be
inefficient.
I presume I need an additional table (for efficiency) to facilitate this but
I am unsure how to incorporate this.
I would think the additional table would hold the PO #, Vehicle reg &
Category ID for either 'Vehicle - Purchase', 'Vehicle - Maint. Repair' or
'Vehicle - Project Repair'.
Any comments would be greatly appreciated.
Many thanks in advance.
(master) and their order lines (detail).
I have a table for 'Categories' (around 30) which can be selected for each
PO line (detail).
I am displaying an additional field in the detail section so that users can
assign a vehicle to that PO line when the user selects either 'Vehicle -
Purchase', 'Vehicle - Maint. Repair' or 'Vehicle - Project Repair' from the
'Categories' drop-down for each PO line. I have a master table with vehicle
details.
I could just add an additional field to the detail table (PO order lines),
but that would mean all records with a category other than those above would
have a field for a vehicle ID which would not be relevant, and would be
inefficient.
I presume I need an additional table (for efficiency) to facilitate this but
I am unsure how to incorporate this.
I would think the additional table would hold the PO #, Vehicle reg &
Category ID for either 'Vehicle - Purchase', 'Vehicle - Maint. Repair' or
'Vehicle - Project Repair'.
Any comments would be greatly appreciated.
Many thanks in advance.