smagboy1
New Member
- Joined
- Mar 17, 2003
- Messages
- 16
Greetings All,
I'm working on a database for my mom (she's opening a consignment shop) that will allow her to enter a) consigners, b) items from said consigners and, c) sales of those items (which will then credit a consigner's account--and should eventually be able to debit the account once she pays them their share, or, if they shop in the store).
I hate reinventing the wheel, but I have not found a suitable template to start from, so I'm winging it, and, though I have some Access experience, this one is challenging me to the core! (does anyone know of a template that I might be missing?)
I've started with three tables: a) cosigners, b) consignment items (multiple items can be linked to individual consigners) which holds fields I'm calling for "final price item sold for," "store's share of final price" and "consigner's share of final price," (these fields will allow me to maintain a consigner's account--I hope) and c) invoice (which just has invoice number and invoice date since all other fields will come from the "consignment items" table).
Where I'm hitting my first stump is that I've made a form for making an invoice for a customer. Customer's might buy several items, and each might be from a different consigner. So, the form should pull in items from the "items" table, but, once mom enters the final sales price (and I've got that working using a sub-form off of the items table), but, how do I best update the consignment item fields once she enters all items and executes the invoice? Should the whole "invoice" form be sourced by an update query?
Thank you for any help you can offer (I know this one is a doozy),
Thanks,
Keith
I'm working on a database for my mom (she's opening a consignment shop) that will allow her to enter a) consigners, b) items from said consigners and, c) sales of those items (which will then credit a consigner's account--and should eventually be able to debit the account once she pays them their share, or, if they shop in the store).
I hate reinventing the wheel, but I have not found a suitable template to start from, so I'm winging it, and, though I have some Access experience, this one is challenging me to the core! (does anyone know of a template that I might be missing?)
I've started with three tables: a) cosigners, b) consignment items (multiple items can be linked to individual consigners) which holds fields I'm calling for "final price item sold for," "store's share of final price" and "consigner's share of final price," (these fields will allow me to maintain a consigner's account--I hope) and c) invoice (which just has invoice number and invoice date since all other fields will come from the "consignment items" table).
Where I'm hitting my first stump is that I've made a form for making an invoice for a customer. Customer's might buy several items, and each might be from a different consigner. So, the form should pull in items from the "items" table, but, once mom enters the final sales price (and I've got that working using a sub-form off of the items table), but, how do I best update the consignment item fields once she enters all items and executes the invoice? Should the whole "invoice" form be sourced by an update query?
Thank you for any help you can offer (I know this one is a doozy),
Thanks,
Keith
