Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.filemaker > #3199
| From | Helpful Harry <HelpfulHarry@BusyWorking.com> |
|---|---|
| Newsgroups | comp.databases.filemaker |
| Subject | Re: Finding & Filling in Prices |
| Date | 2018-09-29 10:48 +1200 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <pomb3t$1ki0$1@gioia.aioe.org> (permalink) |
| References | <51d8f645-41fc-4d1e-ac02-520ef907909b@googlegroups.com> <poksc6$vqm$1@dont-email.me> |
On 2018-09-28 09:30:45 +0000, Erik Appeldoorn said: > Op 26-9-2018 om 18:57 schreef François: >> Hello All, >> >> I’ve got a small problem & would like the experts’ OK before proceeding : >> >> I am trying to help a woman with the following dilemma : >> >> She has goods & is in the midst of a suddenly lost around 500 items, in >> FileMaker, just like that. I suspect iCloud but am more interested >> right now in getting the inventory back on paper & on the books & into >> sales than delving right into the cause. >> >> The main issue is that she raised her prices some time ago & wants to >> be sure to stay within their boundaries.. We’ve always kept track of >> all of the details concerning new purchases as well as price increases >> & any other pertinent details - >> >> My idea was to take a backup - yes, we’ve got many of them, & through a >> look-up, compare all items to note (1) which are missing - not in the >> 'Materials' of the order forms because they are not in the invetory - >> (2) as well as all the exact same items with different prices, which >> would indicate an error & (3) those with the excact same prices. We >> would then print out an entire list for her to check. She’s pretty >> close to knowing all of the costs by heart !! >> >> There you have it. Please excuse my ignorance but I’m worried about her >> a little. >> >> Also, please let me know if this is unclear. I’m also very interested >> in any ‘gotchya’s’ >> >> Thanks for your help. >> >> Josh > > Basicaly OK. I would make a new temporary field for the lookup result. > Not replacing anything in the first stages. Then compare. Then decide > next step. > Ursus Personally I'd probably do the comparisions by exporting the relevant data and then opening it up in Excel / Numbers. It saves any potential accidental damage to the database itself and is often much quicker to do. Helpful Harry :o)
Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar
Finding & Filling in Prices François <geo6121@gmail.com> - 2018-09-26 09:57 -0700
Re: Finding & Filling in Prices Erik Appeldoorn <ursus.kirk@gmail.com> - 2018-09-28 11:30 +0200
Re: Finding & Filling in Prices François <geo6121@gmail.com> - 2018-09-28 09:10 -0700
Re: Finding & Filling in Prices none@gmail.com - 2018-09-28 18:59 +0200
Re: Finding & Filling in Prices François <geo6121@gmail.com> - 2018-09-28 10:49 -0700
Re: Finding & Filling in Prices Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-09-29 10:45 +1200
Re: Finding & Filling in Prices Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-09-29 10:48 +1200
Re: Finding & Filling in Prices François <geo6121@gmail.com> - 2018-09-28 18:22 -0700
Re: Finding & Filling in Prices Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-09-29 18:29 +1200
Re: Finding & Filling in Prices none@gmail.com - 2018-09-29 14:11 +0200
Re: Finding & Filling in Prices François <geo6121@gmail.com> - 2018-09-29 11:06 -0700
Re: Finding & Filling in Prices none@gmail.com - 2018-09-29 20:31 +0200
Re: Finding & Filling in Prices Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-09-30 10:35 +1300
csiph-web