jcarson

I'm working on a database to keep track of ads for a publication. I want to show the ads that each advertiser has posted in a portal on the advertiser's page. There are tables for advertisers, ads and issues. I've attached a bare bones sample. But what I want is to have the ads that show up on the advertiser's page limited by a selection menu for the date of the issue they placed ads in. It's something I've done before with another database, and I just can't figure out why it won't work here. The advertiser Copy Layout is the one that should work with the selection menu. The plain advertiser layout should show all of the associated ads in the portal. Any help is greatly appreciated. sample.zip

I've got a script that creates a new window for someone to enter a search criteria, and I set it to just be like a small pop-up window. However, when I'm viewing the main part of the database in full screen, it always switched to only a partially expanded view when I run the script with the new window. Is there a way to get a new window to open up on top of a window and keep the bottom window in full screen viewing mode? Thanks.

What are the real benefits of getting Developer 7? I've been working for a small consulting company for the past few years and somehow have ended up redoing their databases in Filemaker 7. They had all been in Filemaker 3. I had 0 experience with filemaker or really databases in general before I started working here, but now I'm preparing to leave the company and they've asked me if I'd be willing to do some contract work for them and one of their clients developing a database, since they think I know what I'm doing. Will Developer make the databases any better? and will it save me any time my first go around, or is it just the sort of thing that makes things faster after you've gone through the process a couple of times? I appreciate any thoughts. Jeff

I've got a conference database, with 4 tables: Contacts Events ContactEventsJoin Activities There is a many-many relationship between Contacts and Events with ID fields through ContactEventsJoin and there is a one to many relationship between Events and activities (Many activities at 1 event). Each activity has a cost so in the Activities Table, there's a Name Field and a cost Field for each record (and an Event ID field providing the relationship to Events). In the ContactsEventsJoin Table, there is a field for activities. I've made it a checkbox set using a list of the related values in the Activities table so that I can check off what activities some one is attending at each event. How can I get it to add up all of the costs for the activities that are checked off in that field? Thanks in advance.

I have a many to many relationship of contacts and companies. A company can have several contacts and contacts can be associated with multiple companies. Each contact has a contact type for each company it is associated with. It can be any number of types from the list, but each company can only have one primary contact. This data is stored in a field in the Join table. I want to have a field in the company table that identifies who the primary contact is. I've tried using the calculation: If ( PatternCount ( Company::Primary; "Primary" ); Contact::Full Name) but it only pulls the name sometimes. I think it only pulls the name if it's the first person that was associated with the company. How can I get it to pull the right name? Thanks.

I have a database that has the following tables: contacts companies contactcompanyjoin (contacts can actually be associated with several companies) conferences registrations (a join between contacts and conferences) Contacts and Companies are joined through related ID fields in the contactcompanyjoin table. Contacts and Conferences are joined through related ID fields in the registrations table. Companies are related to a second occurence of the registrations table by both Company ID and Conference ID (so that I can see who is coming to each conference from each company in a portal on the Companies layout) Each Registration Record has a cost field, which is a calculation based on the registration type field. ie Case (Registration Type = "Full"; $500; etc...) Then I have a Total Cost Field in the Registration Table which is a calculation field: Sum (cost field). So in my layout for the company, I can see a portal with all the attendees based on the Conference ID I enter. And the total cost for those attendees shown. It works fine for all of the companies that do not share contacts with other companies. But when a contact is associated with multiple companies, it adds up all of the costs for all of the registrations associated with any of the companies sharing a contact. Anybody have any ideas on what relationships would need to be adjusted? Thanks.

Try specifying a button on the layout to go to a related record. Then click that button to jump to whatever layout you want to go to.

I've got a membership database. And I want to be able to track all members' payments in a table for payments. There's a one to many relationship with members and payments. Each payment will have a different type: Dues, Fall Conference, Spring Conference, Other... It will also have a year associated with it. So it'll be Dues for 2004 of the Fall Conference in 2005, etc. My goal was to have a field for each member with every year they had paid their dues, so I want to pull the dues year from the payment field automatically when the record is created in the payment table. So when I saw this thread, it seemed like a way I might be able to do that. Am I totally crazy for trying to do it this way?

Queue. In your sample file, what if you wanted to put a condition on which fields you pulled into the repeating field. Say you added a boy/girl field for the children and you only wanted the boys to be pulled into repeating field. Where would that condition fit into the calculation?

I must've changed the script around a million times. Never could I click on the field in find mode. I did however find that I could tab into the field in find mode. So I can perform the searches I was hoping to. Thanks.

Ok, made that change, but it still doesn't let me enter any information into the field. Anytime I get the Mouse on that field it turns into a little hand, whether I'm in browse mode or find mode even after I've clicked on it to run the script.

I tried that. I made a script that is If[ not Get(WindowMode) Go to Related Record Else Perform Find/Replace End If So now it goes to the related record in browse mode, and in Find Mode it does nothing, just stays in find mode like I told it to, but I still cannot enter any data into the portal field I'm using as the button in Find Mode.

Does anyone know how to turn a button off in find mode? I want to be able to click on a portal field and go to a related record, but I'd like to also be able to search on the portal field. Thanks.

Exactly, so what Sorem's saying is if the list is out of date the return will be too. Let's say I put 2009 before 2008. It'll recognize 2008 as the last one, just like in your string it recognized "Any" as the value because it came last in the sequence.

Thanks for the help comment. Also, you're right Soren about the problem if the list isn't cronological. But in this case it's easiest for me to just keep the list in order rather than having to update the calculation field every time I wanted add a value to the list. Thanks.