Jump to content

Schalven

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Schalven

  • Rank
    novice
  1. I will ask this question in ignorance. Can I do everything I need in the current file? Have a drop down with all the product ID's and have it pull up the description and price. I was under the impression that I needed to have these related files to be able to pull up these pieces of information from the other places. Namely when I click on the ProdId box I can pull up the brand, ID, Desc, and price. Now I not sure if I am confusing myself too.
  2. All of the original information is in an excel spreadsheet. New Information is put directly into the database. The database is a customer grievance database with Name, address, notes, and issues being in the main database and easy to import from the old spreadsheet. The information that I have in the portals is product ID's, with descriptions and prices that are on a popup in the portals. I can put a record number in the original spreadsheet and then import that into the related databases but will that link them all together in the end? I am not sure if I have explained this correctly. But thanks for any help you can give me
  3. How do I import the parts into the portals and the rest into the main database? Do I need a record number or something in the excell spreadsheet? How do I make sure all the information goes into the right record
  4. I am trying to import an excel spreadsheet into a filemaker database that has several related database fields in portals, such as phones, products and upc numbers. I can import all the data that goes directly into the main database but I have not figured out how to import the data that goes into the portal fields. Anyone out there that can help? Please.
  5. I have a database that I am importing information in from an excel spreadsheet. When I designed the database (due to my inexperience) I put in a bunch of drop down menus. For instance, products and their UPC numbers. I am now trying to import the data but can't get it into the fields that have drop down menus. Is there a way to do this or am I going to have to put the data in by hand?
  6. I have a simple database that we track deductions. Each of the deductions that we log in to the database has a unique transaction ID that we get from our customers (we key this number in manually). Sometimes they send us the same deductions (sometimes months later). Now to my question. Is there some way to know when we put the transaction number in that a message or something will tell us that the transaction was already put in. Thanks for your help
  7. I have a form that has a drop down box with 7 different brands in it. I want to do a report that will give me a count of how many of each brand comes up in the forms from a specified date. Can someone out there help me.
  8. Sorry Lee for putting this in the wrong topic area. I wasn't sure where to put it so I put it here.
  9. To start I am a beginner. But what I need to do is make a database of scanned documents. Is there a way to scan documents, put them in a database and then (link or attach I'm not sure of the proper word) so that I can pull them all up when needed. This is a database for a medium size company that gets all types of documents in daily. It is very time consuming to go to the filing cabinet and many times different filing cabinets to find all the related documents. Does anyone have experience with this or can you suggest somewhere to look.
  10. I probably didn't explain this very good. I have 10 catagories that people put ratings in. Then I have a summary of each of the 10 catagories, I want to then rank these catagories from 1 to 10 so I know which one is most important. The other small problem is that some could have the same rating and I would still like those to be ranked maybe with equal rating and maybe not, I am not sure. Here is an example of the 10 catagories Tot Rank or Rank CatA 7.8 4 5 CatB 8.3 1 1 CatC 7.7 5 7 catD 6.8 7 9 CatE 7.9 3 4 CatF 8.1 2 2 CatG 8.1 2 3 CatH 7.7 5 6 CatI 5.5 8 10 CatJ 6.9 6 8 So that the results could be calculated to rank the results of the catagories in either of the two ways
  11. I probably didn't explain this very good. I have 10 catagories that people put ratings in. Then I have a summary of each of the 10 catagories, I want to then rank these catagories from 1 to 10 so I know which one is most important. The other small problem is that some could have the same rating and I would still like those to be ranked maybe with equal rating and maybe not, I am not sure. Here is an example of the 10 catagories Tot Rank or Rank CatA 7.8 4 5 CatB 8.3 1 1 CatC 7.7 5 7 catD 6.8 7 9 CatE 7.9 3 4 CatF 8.1 2 2 CatG 8.1 2 3 CatH 7.7 5 6 CatI 5.5 8 10 CatJ 6.9 6 8 So that the results could be calculated to rank the results of the catagories in either of the two ways
  12. I am a beginner and have a simple application that has ten catagories that need to be ranked. How would I go about ranking these catagories from 1 to 10.
×
×
  • Create New...

Important Information

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