Hey Roger! Well I'm glad that we made a good start to this but I'm pretty
sure we can overcome your other problems too. Ok I have several idea's and
several questions so lets get to it...
Why is it important/beneficial to allow a different employee for services vs
retail items?
Lets address your problem with your report which seems to be your main
problem. I'm assuming your report is based upon a query which puts all the
data together. Your report problems should be solved by making several
groupings. You want to group Customers and Orders, and also hide duplicates.
This way you should get a report like this...
Oh yeah and also you should/could have a filter in your query so that your
report will only show the data for one customer and one order. That way you
can make it look like an individual receipt... unless you want it to show all
orders???
<Now as also mentioned below you may not want the customer infor to be part
of this system but the logic for the rest is still the same>
Customer: Frank Zoodle
Order: 1000596
Date:
Items Purchased Quantity Price
Shampoo 1 $5.00
Hair Wash 1 $15.00
Perm 1 $40.00
Subtotal 3 $60.00
Taxes 5.45
Total $65.45
Customer field would be in teh customer header. Order in the Order hearder,
and Your items-qty-price would appear in teh detail part of the report. the
calculations would be in the report footer or probably better in the Order
footer. Now to calculate the correct taxes you need to try one of two things.
.. see if you can create a formula to isolate the taxible items and calculate
the tax on those or... create a subreport based upon a query which WILL
isolate them. This will be discussed more later so keep reading...
Also describe to me in more detail what the problem is with the appearance of
your form.
So my suggestion for your form is if you plan to track customers then to have
a main form based upon table Customers. Otherwise the main form can be based
upon table 'Orders' Lets assume for now that you don't track customers. In
ths case you only need three tables...
1. You will have a table tblItems which will simply contain all possible
things that can be purchased at your salon. This table will have fields Item,
Price, and one other field that could either identify the item as Service or
Product or taxible vs non.
2. The second table will track all orders placed with simply have an
autonumber primary key--> OrderID to track your orders, and probably a Date
field to automatically enter the current date. You could also have a
combobox based upon another table to select employee taking the order.
3. The third table will track Order details with a OrderID, OrderDetailID and
ItemID field which will be a lookup field from table tblItems.
So your form with have simply one main form based upon table Order and one
sub form based upon tblItems.
for your tax calculation what I suggest is creating a query which identifies
all items on the current order which are taxible and then having another
subform on the main form which will display the total tax amount. This is
why we created the field to isolate taxible vs non in the tblItems. There
may be a formula you can create on the main form only to identify and
calculate them without the query but offhand I don't know how to do so.
Someone else may though. To ensure the query gets the correct value ensure
the subform refreshes each time you either select a different order or change
or add an item.
This might be the best type of technique to calculate taxes ont he report
also but using a subreport there.
I know this is a lot but I hope this helps.
I have done exactly what you sugested with one subform for retail and another
sub for services. This is good because it alows me to choose a diferent
employee for services and retail items. This all works and all control on the
main form work also. The problem with that is wiith the report and the overal
appearance of the main form. Since the main fom is linked by child and master
on the subs it gives one order id on the main form that corelates to several
records on the subs. This causes the report to list each reecod seperately.
So in that case the report repeates the orider id from the main form serveral
times . I hope that made sense. Thank you for your idea it does work that way
but isn't quite what i'm looking for. Roger..
Unfortunately I don't know how to do exactly what you want but I'm sure its
possible and someone more knowledgable than I can tell you cause I'd like to
[quoted text clipped - 18 lines]
calculating tax on retail. Basicaly I want the list to look like a receipt.
Any suggestions on how to do this would be appreciated. Thank You.