Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rikki

  • Rank
  1. Relationship help

    This list was just an example of one "type" there can be 4 "types" but they all have the same sort of data just the source is different so I need to be able to distinguish between the 4 types of lead count (back data, profile, survey & 2nd use) there are around 30 suppliers in the table and 150 postcodes. I need all 30 suppliers to be able to track 4 different lead type counts.
  2. Relationship help

    I don't actually need to report on any data in the leads table for this purpose. The supplier will send me a list like this: Postcode Count AB 528 AL 222 B 1062 BA 408 BB 492 BD 426 BH 600 BL 342 BN 828 BR 264 BS 882 BT 1548 CA 492 CB 414 CF 1062 CH 618 CM 528 CO 582 CR 288 CT 438 CV 744 CW 276 DA 348 DD 324 DE 810 DG 264 DH 330 DL 396 DN 882 DT 240 DY 600 E 210 EH 678 EN 192 EX 684 FK 174 FY 390 G 648 GL 546 GU 528 HA 342 HD 252 Hg 102 HP 384 HR 276 HS 96 HU 522 HX 204 IG 240 IM 90 IP 618 IV 216 KA 414 KT 348 KW 120 KY 432 L 420 LA 312 LD 78 LE 1146 LL 678 LN 360 LS 534 LU 306 M 510 ME 534 MK 420 ML 354 N 198 NE 1422 NG 1320 NN 744 NP 594 NR 894 NW 150 OL 294 OX 552 PA 342 PE 1140 PH 138 PL 660 PO 948 PR 660 RG 624 RH 432 RM 462 S 972 SA 852 SE 408 SG 330 SK 474 SL 240 SM 150 SN 450 SO 540 SP 192 SR 210 SS 498 ST 642 SW 222 SY 432 TA 444 TD 138 TF 204 TN 726 TQ 282 TR 474 TS 816 TW 312 UB 240 WA 666 WD 150 WF 432 WN 408 WR 342 WS 492 WV 498 YO 816 My goal is to import these counts from an excel spreadsheet into the database so I can keep track of these counts for each of the 4 lead types for each supplier.
  3. Relationship help

    I can understand how you see that. I will try to explain a little better. The database I am working on uses a new external file for each table. The leads table is actually in a different file and isn't referenced from here (the suppliers database) the count for each postcode isn't based on leads currently in the database, it is actually the count that the supplier is able to provide but we haven't yet purchased. In my screenshot the __Default table is actually the supplier database table.
  4. Relationship help

    Hi guys, Sorry I do not know the terminology of what I need. I am trying to setup a database to record some info on postcodes. What I need to do is, each supplier can have 4 types of lead (back data, profile, survey, 2nd use). I have two tables for suppliers and postcodes already. I also have 2 join tables for many to many relationships. I need each field in the postcodes database to be able to store a count for each supplier's lead type. Eg: Supplier - Lead Type - Postcode - Count Supplier A - Back Data - AB - 20 - BB - 155 - CB - 30 Profile - AB - 55 - BB - 27 My problem is with the way I have set the relationships up currently. When I add a count for a postcode it adds that count for all suppliers. I need the postcode count to be specific to each supplier and lead type. Can anyone tell me what I need to do to get this working correctly? I have attached a screenshot of my relationships. Thanks
  5. Charting forecast

    My problem with that is like I stated originally, I don't know how I would make it produce a chart like my example. This is why I created a new table called CHARTS and added 10 records (one record per year) In my example chart each "year" is a record, I could add a new record and name the "YEAR" field "Year 11" and it would then show in the chart, then I would have to add a new "Case" in the calculation to show the value for year 11. I just cannot get my head around how I would write a calculation for the horizontal axis to show the ten years.
  6. Charting forecast

    The Financials table is related to the customer database by the customer ID, it just stores many calculations that I use to generate a bunch of reports per customer. It only has 1 record per customer not multiple. The only reason I am not doing this from the Customers database is because it has 1.5 million records and is being accessed non-stop by the telesales guys, so if I add hundreds of new fields it takes ages to update all 1.5 million records with the modifications and during that time all of the telesales guys are locked out of the records for the duration and it cause a lot of problems. I decided I would just use a new table and relate it to the customer table to save hassle in that respect. Also I do not need to generate these reports and charts for every customer in the database just certain ones. From the customers database I use a script to insert the customer ID into the foreign key field in the Financials database, so only the customers that I chose have a financials report. I understand that it is "pointless" in your eyes as it doesn't "look" different but I have been asked by the boss to do it so that the customers can see a chart, instead of just the numbers in a table.
  7. Charting forecast

    Sorry I forgot to mention Financials::heating_billIs the field where the data is stored and I would like to relate to this field from my CHART table. I am using the data in this field to manually enter it's value into the CHARTS::Heating_Bills field to generate the chart. The Financials table stores data for another report for the heating bills but I don't know how to chart the data from this table how I would like, so I have created this new table called "CHARTS" because I couldn't think of another way to display one bar per year via the Financials table. This is the result I want but the only way I could think of producing a chart like this is to have 10 records in a new table so that there is 1 bar per year for the 10 years I need to forecast. Sorry, I am fairly new to Filemaker so it's probably something fundamental I am missing.
  8. Charting forecast

    I have 2 tables. First table is named "Financials" and is related to the customers database by the customer ID. In this table I have a field named "heating_bill". Second table is named "CHART". In this table I have created 10 records and filled out the "YEAR" text field with a year like so: YEAR="Year 1", YEAR="Year 2", up to YEAR="Year 10". I have used the "YEAR" field for my horizontal (X) axis on the chart so that I have one bar per year showing, then in the vertical (Y) axis I have a calculation using case to show the projected heating bill year on year with an 8% increase every year. My calculation is like this: Case( CHART::YEAR="Year 1";CHART::Heating_bill; CHART::YEAR="Year 2";(1.08)*CHART::Heating_bill; CHART::YEAR="Year 3";(1.08^2)*CHART::Heating_bill; CHART::YEAR="Year 4";(1.08^3)*CHART::Heating_bill; CHART::YEAR="Year 5";(1.08^4)*CHART::Heating_bill; CHART::YEAR="Year 6";(1.08^5)*CHART::Heating_bill; CHART::YEAR="Year 7";(1.08^6)*CHART::Heating_bill; CHART::YEAR="Year 8";(1.08^7)*CHART::Heating_bill; CHART::YEAR="Year 9";(1.08^8)*CHART::Heating_bill; CHART::YEAR="Year 10";(1.08^9)*CHART::Heating_bill; ) Now I would like to do this another way that is more automated because with this design I can only do it manually by entering the current heating bill of the customer into the "CHART::Heating_bill" field and then the chart is generated. I need it to work from a relationship but I cannot get my head around how I would need to do it because I need to show the 10 years, so the only way I could think of doing that is creating a record for each year in the chart. Is there a better way that I can do this with a relationship and a calculation to make it more automated? Regards Rikki
  9. Hi guys, I have a strange problem with a value list in one of my databases. I added a value list and set it to display a list from a field of employees. It worked for a while but after closing the database and re-opening it, the drop-down value list no longer works. I then checked in File>Manage>Value Lists and my new value list has no name anymore and I cannot delete it or edit it, it is just completely bugged out! I thought I would try again and re-create the value list and set it as the drop-down, but exactly the same thing happened, it has no name and is undeletable/uneditable! Now I have two bugged out value lists stuck in my database and I am unable to remove or edit them and I still haven't managed to create this value list without this problem happening. Can anyone point me in the right direction to fix this issue? The database in question has a lot of records (1.5 million) so I am worried it is a major problem. Regards Rikki

Important Information

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