Asking for help is never a dumb question.
I suggest backing up and taking a careful look at your tables and relationships.
Do you have one table where one record records the name and contact data for a single customer and a second table where one record records a single vehicle purchase for a given customer? That structure will make life easier in a lot of ways.
There's a lot of ways a find can fail to perform as expected. Solving them require a more detailed look at exactly what you have and how you tried to set up the find request(s). It might help to give an example of how you've tried to find a group of records and how it failed to work for you.
I deleted all the previous scripts i did because they weren't working with anything so im pretty much starting from scratch again thats why i posted...The only way i found i could go through the list to add contacts according to what they had bought is to add a box on the "Select list- Contacts" which pops up when i want to add contacts to the group i created but i have to add a box for each vehicle field if i want it to show up on the list and then i have to manually click each contact that i want add
Is there an easier way to do this?
I didn't want to fight with what i had done so i took it back to everything that does work these are some screen shots of what it looks like
So what i need it to do is some how create a group seperately by all vehicle fields (Make, model, type) but include vehicle 1,2,3,4...So Model from vehicle 1,2,3,4... creates a group for each model "value" that is the same and adds the right contact to the respectable group
I created a field for each vehicle so Vehicle 1 has its own seperate Vehicle1model, vehicle1type, vehicle1color etc.
and vehicle 2,3,4 are the same way
I hope that makes sense...
Your screen shots don't show in my browser :smileysad:
Just going from "...but i have to add a box for each vehicle field if i want it to show up on the list..." suggests that you have defined a separate field for each vehicle. If so, this will create major problems for you when you try to find, analyze or report data from your database.
You should have at least two tables to track customers and their purchases. Your customers can be your Contacts table, but you need an additional table where you can record purchases using the following basic format:
ContactID (number, use Relationships tab to link field to contacts::ContactID)
Date Purchased (Date)
//any other fields you need to document the purcase of one vehicle.
You can then create a layout based on Contacts and create a portal showing all vehicle purchase records for that customer.
I suggest you invest in learning more about Filemaker and databases. There are books on the subject. There are classes and tutorials available. This can give you some good "background" to help you better understand the various posts in this forum. By all means keep posting your question here as well.
I belong to biznik.com and attended an event about email advertising.
One of the examples was an event response setup for an automotive service company.
Seemed cool. Unsure of cost.
www.emailbroadcast.com is the company.