Milothicus
Registered User.
- Local time
- Today, 08:09
- Joined
- Sep 24, 2004
- Messages
- 134
I have some ideas on how to do this, and with which events to trigger it, but i want to hear other people's thoughts on it:
I have a purchase order creation DB with a table of standard parts... about 350 items.
orders can also include custom 1-off items, so i decided to simply add them to the standard table, with a yes/no field to indicate wether an item in the table is a custom item.
so... my main form is open to a particular order.
click on an 'Add Custom Items' form (only shows items for this order that have 'CustomItem' checked in the table...
click on 'new item', which sends the form to a new blank record, and the user can input the data for the new custom item.
click on 'Save/Close', and the form closes, adding the new item to the current order.
at what stage is it best to mark the new item as a custom item?
I have a purchase order creation DB with a table of standard parts... about 350 items.
orders can also include custom 1-off items, so i decided to simply add them to the standard table, with a yes/no field to indicate wether an item in the table is a custom item.
so... my main form is open to a particular order.
click on an 'Add Custom Items' form (only shows items for this order that have 'CustomItem' checked in the table...
click on 'new item', which sends the form to a new blank record, and the user can input the data for the new custom item.
click on 'Save/Close', and the form closes, adding the new item to the current order.
at what stage is it best to mark the new item as a custom item?
