Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About charisse

  • Rank
  1. I think that this would work well for me, but I am not clear as to what the "breakField" refers.
  2. Can belong to multiple events, but only sold once.
  3. Yes, I only need to track actual sales. And yes I agree that I don't need the join table. My issue is that the price field originates in the event databases, (and there are 24+ events with approx. 4 new event databases created annually), not in the products/inventory table. If I put a field for the actual selling price on the record in the products/inventory table, the data will need to be "delivered" to it somehow. If via the relationships then I would need to put a price field for the "actual selling price" on the product record in the products/inventory table for every event, some
  4. The selling price comes from the event. Each event is it's own db. Each item/product is unique and can only be sold one time. The 15,000 records in the inventory/product table are 15,000 unique items. There are no list prices (not that this really matters). I will study the demo and see if I can apply the principle. Thank you.
  5. Yes, I understand the whole affair is quite complicated an convoluted. I am trying to make the best of what I have been given to work with. I import only the needed records (products) to the specific event (600-880 per event). I guess I am not understanding how to get the selling prices into the join table other than by calculation.
  6. Let me try to clarify... I have a database of products each of which are unique and have a quantity of one. A group of these products may be offered in a sales event. Each sales event is it's own database. If a product sells I need to retrieve the price for which it sells and show that amount on the corresponding record in the products database. I thought about the join table approach but it seemed somewhat pointless as all the record are related by the same id-field and I was still needing to "fetch" the actual selling prices with a calculation.
  7. I have written a calculation to display sales prices (from multiple tables) on my main product table. Each product is unique and has only one selling price, but it may have been offered in multiple sales events. The calculation works, but I am wondering if this is the best way to approach the task. Case ( not IsEmpty (Auction 16_04::Hammer) ; Auction 16_04::Hammer for Inventory ; (Auction 16_02::Hammer) ; Auction 16_02::Hammer for Inventory ; (Auction 15_11::Hammer) ; Auction 15_11::Hammer for Inventory ; (Auction 15_09::Hammer) ; Auction 15_09::Hammer for Inventory ; (Auctio
  8. Good to know. I will give that a try. Thank you both.
  9. The first time I run the script it seems to take the time to create the pdfs/invoices. The second time I run the script in completes in a fraction of the time generating email with no pdf. I am not too familiar with the debugger. I think I have the toolbars showing, but I am not sure how to see the record count, total records, pdfs generated etc. I stepped through the script and as I did so, the pdfs (should be one per email) were created on the emails. I am thinking that the script is running too fast to generate the pdf the second time around? I put in a 1 second pause after t
  10. Yes, the script runs (very quickly BTW) and shows no errors, but there are no pdfs attached to the emails generated (except for the last email which has the pdf for the last record attached).
  11. I have written two scripts to email invoices to customers. The first time I run the script everything works fine, but if I need to run the script again the emails are created, but only the final email has a pdf attached. If I close both of the databases involved the script runs properly again (one time). Any ideas? Thanks!
  12. I will give that a try. Thanks! P.S. I agree about the invoice status. Unfortunately, that is just a small part of a much larger problem. We have one solution for inventory management and a separate (independent) solution for each "sales event." They do not seem to communicate with each other very well. The invoices live with the event. The invoice status lives with the inventory, I am assuming because the inventory would not know where to go to get the status because of the many "events." I am sure this is all very confusing, I find it quite overwhelming at times myself. I inherited
  13. I have a layout in which invoices can be marked via a radio button selection "Paid" or "Unpaid." I am trying to write a script that will only print the invoice if it has been marked as paid, if unpaid send a message to the user (custom dialog box) that the invoice is not yet paid, but I do not know the correct syntax. I have been trying to use an "if" statement, but that is not working for me. Any help would be appreciated. Thanks!
  14. Thanks comment! & "-" & MiddleWords ( Lower(D1); O; 1 ) worked perfectly.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.