JenNicole

I would love to do this for you, however, here is my problem. I have to take an existing database built in SQL and C#, built by a retired engineer from Crane. The database he built for us is and has been a total nightmare! We originally worked with Filemaker, but he took our information from that and created this monstrosity that we are now dealing with on a daily basis. Now I am left to deal with his mess and try to create something close to what we had before when we first used Filemaker. I have had trouble changing the way his tables relate when putting it into Filemaker due to the way he created his relationships. The way the relationships are in the tables I have placed into Filemaker is the exact same way he had his related in his database. When I try to change something about them, it changes everything and I will suddenly have missing information. Therefore, I will gladly do what I can to make you better understand what I have here, but I am unsure of how to make the changes you are suggesting without having missing information in the end. I apologize for whatever headache this may cause but I am doing my best with what I have here. I will do my best to make some sort of a flowchart with these tables, but I am unsure of how successful I will be……..more to come. Wish me luck! Until then, if there is some way to solve the source code issue, I will greatly appreciate any help you may have! Thanks again!

I am hoping this works.....never tried to clone it to post on here. Let me know if you are not able to manipulate it. The scripts should be there as well. I cleared out all records except for 2 to test it. Again....any help would be greatly appreciated! JenNicole.zip

Hello everyone! Once again, I have ran into a small problem that has now become a major hold up in the design of my database! I have a table labeled [color:red]Source Codes, which identifies the payment entries origin. There is a [color:orange]source code(a mixed line of letters & numbers not exceeding 15 characters) and there is a [color:purple]source code description(a description of the code itself, the only thing all data entry users will see). There is another table labeled Payments, which is where the data entry user records members payments. In this table I have place a field for [color:purple]source code description. However, in doing so, the user was unable to enter anything into this field, let alone tab to it. The tab would automatically skip over it as if it did not exist! The only time entry was allowed at all was in an existing payment entry where you were able to edit it. Upon trying to solve this problem we discovered that each time a payment was put in, the [color:purple]source code description selected was added on to the bottom of the [color:red]source code table with a [color:orange]source code that did not match. What is the deal here? How do I fix this? Any help will be much appreciated! Thanks in advance!

I am not sure what a webview is... much less an empty one. AND My layout is simply in browse mode.. don't know to make it pop-up. All help appreciated. thanks

I saw that post and it does not save the record until you click on the 'Save' button but I cannot figure out how he does it... any thoughts? Thank you.

The save as you go I can deal with as long as I can force it to run one last script upon exit... last thing it does before saving the record... This is why I was heading in the 'Save' button direction... any thoughts? Thanks

Hello All, I have a quick question. I have a layout in which I want the user to HAVE to click on my 'save' button. Currently all you have to do is exit the record or click somewhere outside the fields and the record will be saved. I have a 'save' button and it works but it is not mandatory... I want to make it mandatory. All help is appreciated.

Thanks for the help, but I just went with creating a report layout for it, which worked quite well I may add! This way I didn't have to delete the extras. Thanks again!

Ok I appreciate your help in answering this, however, I am thinking I may have left out a bit of information in my initial explanation. I am in need of the following outcome: AL = 66 CA = 77 and so on. I can get it to where it will show me the state name and how many current members, but if there are 77 members in CA, it will show 77 lines for this. I am in need of one line per state with the total. This way, at the bottom of the screen I can get an accurate total number of current members in all states. I hope I am explaining this a little better this time. My apologies for not doing this the first time round. The link below is kind of what I am dealing with, but am having trouble getting this result. Plus, I believe what is shown in the topic below may be a little more than what I am needing. http://www.fmforums.com/forum/showtopic.php?tid/199752 Thanks again! :)

Hello All, I need help with a task. I have a database with 30000 records representing members.... I have a field for 'State' and a field for 'Current'. All I want to generate is a report that lists each state and how many current members within each state. So for example the report would be: AL =96 CA=77 and so on ... So far I have used a script to isolate these records and a summary field to list the total within the state but I cannot list more than 1 state at a time.... Do I achieve this through a portal or :? I may be making this harder than it is, but any help you may be able to provide would be greatly appreciated!

Thanks for your response. I understand getting away from text values for payment.. but this particular database already has 30K records in it and I am just getting started with FM. Previous DB was custom C# and SQL.. anyway.. besides the point. I have tried what you said (it makes sense) but don't understand how to calc the payment_for... I other words.. my payment_for field contains only 3 types of data based on a value field of "Dues", "Contributions", and "Event/Purchases"... I need to somehow filter the results to show only records where the Payment_For="Dues". I know you have provided the answer and I appreciate your help.. but maybe I need it explained in a more elementary way.. All help appreciated. Thanks again.

I have researched only simple filtered portals and most seem to point in creating a global field in the parent table.... About global fields: I have tried to validate it text only ="Dues" and tied this in with my 'payment_for" field in the other table but I am having no luck... Perhaps I need help creating my global field... All help appreciated.

I will have to see what I can do with this then. I am dealing with a pre-existing database created by a person employed previously. The only problem I seem to be running into is the fact that is was written in C# and SQL. There seems to be some unexplainable coding in there that is almost unnecessary or will seem to block things. I don't know, I have cracking it slowly.............very slowly.......... Thanks again!..........have a great weekend! :waytogo:

This is correct, but we do also accept payments for Contributions and Merchandise purchases. Therefore, their status could very well be blank unless it pertains to a Dues payment. We have Donor Types in the database as well. They can be a 'Donor', 'Member', 'Junior Member' or even a 'Lifetime'. Before I get to into detail, I figure if I can get one field to auto-complete upon entry of another I will be doing great! Thanks..........hope this helps to better understand what I am looking at. :laugh:

Actually we have an expiration date! However, you cannot say greater than today simply because they set for the end of each month and some may send in payment that already have an expiration date 2 years from now, but it will need to add onto this date. I had originally thought to make the Payment For and Expiration Date tied together, then pull the Status in from there. I just noticed I had told you it was ntapay2::Payment For and ntanames2::Expire Date when in reality I was speaking of the following: ntapay2::Payment For = "Dues" then (autofill) ntanames2::Status = "Current" This may make a little more sense now!