I have a list of Camping Items for  a trip.

I have a list of Required Camping Items for a trip.

Can I get filemaker pro to Identify what items I allready have and what
Items I still need?

TIA

Seems very easy.
Just one file with 2 fields is about as simple as Filemaker gets.
First field, Item Name with a type of text
Second field, Date Procured  with a type of date.
Sort the file by date and the ones not procured will be at the top.
Easy.
I am sure you will get offers of much more complicated fles and even
existing templates with many more functions but to start simple thats all
you need for what you asked I believe.
But Filemaker is very easy to grow, you can add fields and build all sorts
of layouts as you need or learn more.
Good Luck.
-- 
John G

Wot's Your Real Problem?

"Mr. C." <martinc6868@yahoo.com> wrote in message
news:171120031552476576%martinc6868@yahoo.com...
> I have a list of Camping Items for  a trip.
>
> I have a list of Required Camping Items for a trip.
>
> Can I get filemaker pro to Identify what items I allready have and what
> Items I still need?
>
> TIA

In article <3fb969d6$0$13682$afc38c87@news.optusnet.com.au>, John G
wrote:

> Seems very easy.
> Just one file with 2 fields is about as simple as Filemaker gets.
> First field, Item Name with a type of text
> Second field, Date Procured  with a type of date.
> Sort the file by date and the ones not procured will be at the top.
> Easy.
> I am sure you will get offers of much more complicated fles and even
> existing templates with many more functions but to start simple thats all
> you need for what you asked I believe.
> But Filemaker is very easy to grow, you can add fields and build all sorts
> of layouts as you need or learn more.
> Good Luck.

The problem is that I have one file with all the requirements for
camping trips, vacation trips, island trips, etc.

The other file contains client names with the trip they are interested
in, ie, island trip.

What I would like to may be a little more complex since i split the
data into two seperate files,  the requirements list and the procured
list.

I hope Im not making this too complicated?

TIA

Yes it is more complicated than I could describe.
It seems to need related files of clients and trips and equipment and whilst
I am sure that is not too big a task for a full time developer it is out of
my league.
-- 
John G

Wot's Your Real Problem?

"tester" <martinc6868@yahoo.com> wrote in message
news:171120031718113554%martinc6868@yahoo.com...
> In article <3fb969d6$0$13682$afc38c87@news.optusnet.com.au>, John G
> wrote:
>
> > Seems very easy.
> > Just one file with 2 fields is about as simple as Filemaker gets.
> > First field, Item Name with a type of text
> > Second field, Date Procured  with a type of date.
> > Sort the file by date and the ones not procured will be at the top.
> > Easy.
> > I am sure you will get offers of much more complicated fles and even
> > existing templates with many more functions but to start simple thats
all
> > you need for what you asked I believe.
> > But Filemaker is very easy to grow, you can add fields and build all
sorts
> > of layouts as you need or learn more.
> > Good Luck.
>
> The problem is that I have one file with all the requirements for
> camping trips, vacation trips, island trips, etc.
>
> The other file contains client names with the trip they are interested
> in, ie, island trip.
>
> What I would like to may be a little more complex since i split the
> data into two seperate files,  the requirements list and the procured
> list.
>
> I hope Im not making this too complicated?
>
> TIA

I don't think it needs to be difficult, but it requires at least one
relationship, possibly more, DEPENDING on the structure of your other file. Do
you have a list of names with checkboxes beside equipment (i.e.
Item   n1 n2 n3 n4
stove   1   0   1   1
canoe  0   0   0   1

or a matched list (i.e.
n1 stove
n1 canoe
n3 stove
n4 stove
n4 canoe

You need to relate the two equipment fields, then create a layout displays the
content of the match field, if there is anything there. The equipment would need
to be spelled the same in all cases to get a match, or entered as an ID like
canoe =18 stove = 26 etc.

This isn't something that I could easily describe without extensive knowledge of
the structure of your two files. If you are willing to forward the two files, or
even pared down versions, with only a few records in each, I would be prepared
to take a quick look as it might be fairly simple. (Again, depending on what the
two files actually look like.) kent_pollard at hotmail ( .com of course,
recognizing that hmail can only take attachments up to about a meg or two.)

Kent


"tester" <wrote...
> The problem is that I have one file with all the requirements for
> camping trips, vacation trips, island trips, etc.
>
> The other file contains client names with the trip they are interested
> in, ie, island trip.
>
> What I would like to may be a little more complex since i split the
> data into two seperate files,  the requirements list and the procured
> list.
>
> I hope Im not making this too complicated?
>
> TIA

In article <N7oub.426749$9l5.236869@pd7tw2no>, Kent at home
<invalid@hotmail.com.invalid> wrote:

> I don't think it needs to be difficult, but it requires at least one
> relationship, possibly more, DEPENDING on the structure of your other file. Do
> you have a list of names with checkboxes beside equipment (i.e.
> Item   n1 n2 n3 n4
> stove   1   0   1   1
> canoe  0   0   0   1
> 
> or a matched list (i.e.
> n1 stove
> n1 canoe
> n3 stove
> n4 stove
> n4 canoe
> 
> You need to relate the two equipment fields, then create a layout displays the
> content of the match field, if there is anything there. The equipment would
> need
> to be spelled the same in all cases to get a match, or entered as an ID like
> canoe =18 stove = 26 etc.
> 
> This isn't something that I could easily describe without extensive knowledge
> of
> the structure of your two files. If you are willing to forward the two files,
> or
> even pared down versions, with only a few records in each, I would be prepared
> to take a quick look as it might be fairly simple. (Again, depending on what
> the
> two files actually look like.) kent_pollard at hotmail ( .com of course,
> recognizing that hmail can only take attachments up to about a meg or two.)
> 
> Kent
> 
> 
> "tester" <wrote...
> > The problem is that I have one file with all the requirements for
> > camping trips, vacation trips, island trips, etc.
> >
> > The other file contains client names with the trip they are interested
> > in, ie, island trip.
> >
> > What I would like to may be a little more complex since i split the
> > data into two seperate files,  the requirements list and the procured
> > list.
> >
> > I hope Im not making this too complicated?
> >
> > TIA
> 
> 
There are four files involved in what I am trying to do.

FILE 1 is the parent to file 2 and contains;
Trip Types, ie , camping, fishing, disney florida, etc.

FILE 2 is the child of file 1 and contains:
items for each trip type, ie for camping,
pocket knife,
tent,
cooking pan,
propane,
etc.

FILE 3  is the parent to file 4 and is the clinet list where I select
what trip he/she is interested in.   Once selecting what trip they are
in, a portal from FILE 2 shows up with what they will need for that
trip, ie
camping
pocket knife,
tent,
cooking pan,
propane,
etc.

FILE 4 is the child  of file 3 and this is where I list the items the
client has actually secured, ie for camping
tent,
propane,
etc.

I would like to be able to compare FILE 4 (actual items in possession
with) FILE 2 (items needed for trip)

I hope this make it easier to understand.  

Please let me know if this helps.

TIA

I see a few alternatives for you, any one of which might (or might not) 
work for you.

1) If all you really need is to determine whether or not the client has 
secured all items, you could use a calc in File3 that compares 
count(File2::Description) to count(File4::Description).

2) Another way to approach it is to click a button once the trip type is 
entered.  The script attached to this button would go to the related 
File2 items (showing only the related), then import those File2 items 
into File4 and set the client ID in the File4 records.  The result will 
be that, while in File3, your File4 portal will list all needed items. 
Just add a checkbox field to indicate whether or not the client has 
actually secured the item and mark them as you go.  No need for the 
portal from File2 in this case; its all in File4.

Need more?  Let us know why either of the above won't work and I'll 
offer some more complex solutions.

tester wrote:

> There are four files involved in what I am trying to do.
> 
> FILE 1 is the parent to file 2 and contains;
> Trip Types, ie , camping, fishing, disney florida, etc.
> 
> FILE 2 is the child of file 1 and contains:
> items for each trip type, ie for camping,
> pocket knife,
> tent,
> cooking pan,
> propane,
> etc.
> 
> FILE 3  is the parent to file 4 and is the clinet list where I select
> what trip he/she is interested in.   Once selecting what trip they are
> in, a portal from FILE 2 shows up with what they will need for that
> trip, ie
> camping
> pocket knife,
> tent,
> cooking pan,
> propane,
> etc.
> 
> FILE 4 is the child  of file 3 and this is where I list the items the
> client has actually secured, ie for camping
> tent,
> propane,
> etc.
> 
> I would like to be able to compare FILE 4 (actual items in possession
> with) FILE 2 (items needed for trip)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

I can follow your example number 2.  And I like this solution!  Can you
explain example number 1 a little bit more? How would the calculation
in File 3 campare the counts from File 2 to counts from File 4? 

I am begining to think that trying to compare lists is the wrong
approach in our administrative procedures.  Just checking things off
after importing them would be so much easier!

Thank you verry much for your help!

Martin


In article <vrodu2gk4qhu69@corp.supernews.com>, Howard Schlossberg
<howard@antispahm.fmprosolutions.com> wrote:

> I see a few alternatives for you, any one of which might (or might not) 
> work for you.
> 
> 1) If all you really need is to determine whether or not the client has 
> secured all items, you could use a calc in File3 that compares 
> count(File2::Description) to count(File4::Description).
> 
> 2) Another way to approach it is to click a button once the trip type is 
> entered.  The script attached to this button would go to the related 
> File2 items (showing only the related), then import those File2 items 
> into File4 and set the client ID in the File4 records.  The result will 
> be that, while in File3, your File4 portal will list all needed items. 
> Just add a checkbox field to indicate whether or not the client has 
> actually secured the item and mark them as you go.  No need for the 
> portal from File2 in this case; its all in File4.
> 
> Need more?  Let us know why either of the above won't work and I'll 
> offer some more complex solutions.
> 
> tester wrote:
> 
> > There are four files involved in what I am trying to do.
> > 
> > FILE 1 is the parent to file 2 and contains;
> > Trip Types, ie , camping, fishing, disney florida, etc.
> > 
> > FILE 2 is the child of file 1 and contains:
> > items for each trip type, ie for camping,
> > pocket knife,
> > tent,
> > cooking pan,
> > propane,
> > etc.
> > 
> > FILE 3  is the parent to file 4 and is the clinet list where I select
> > what trip he/she is interested in.   Once selecting what trip they are
> > in, a portal from FILE 2 shows up with what they will need for that
> > trip, ie
> > camping
> > pocket knife,
> > tent,
> > cooking pan,
> > propane,
> > etc.
> > 
> > FILE 4 is the child  of file 3 and this is where I list the items the
> > client has actually secured, ie for camping
> > tent,
> > propane,
> > etc.
> > 
> > I would like to be able to compare FILE 4 (actual items in possession
> > with) FILE 2 (items needed for trip)
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 883-2846
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance
>

In File3, create a new calc field (number result):

count(File2::Description) = count(File4::Description)

If they are equal, then the result will be 1; otherwise the result will 
be 0.  Put the field on your layout, formatted as a checkbox, with its 
valuelist value as '1'.  It will be automatically marked with an X if 
the number of related items in file2 is the same as the number of 
related items in file4.


tester wrote:

> I can follow your example number 2.  And I like this solution!  Can you
> explain example number 1 a little bit more? How would the calculation
> in File 3 campare the counts from File 2 to counts from File 4? 
> 
> I am begining to think that trying to compare lists is the wrong
> approach in our administrative procedures.  Just checking things off
> after importing them would be so much easier!
> 
> Thank you verry much for your help!
> 
> Martin
> 
> 
> In article <vrodu2gk4qhu69@corp.supernews.com>, Howard Schlossberg
> <howard@antispahm.fmprosolutions.com> wrote:
> 
> 
>>I see a few alternatives for you, any one of which might (or might not) 
>>work for you.
>>
>>1) If all you really need is to determine whether or not the client has 
>>secured all items, you could use a calc in File3 that compares 
>>count(File2::Description) to count(File4::Description).
>>
>>2) Another way to approach it is to click a button once the trip type is 
>>entered.  The script attached to this button would go to the related 
>>File2 items (showing only the related), then import those File2 items 
>>into File4 and set the client ID in the File4 records.  The result will 
>>be that, while in File3, your File4 portal will list all needed items. 
>>Just add a checkbox field to indicate whether or not the client has 
>>actually secured the item and mark them as you go.  No need for the 
>>portal from File2 in this case; its all in File4.
>>
>>Need more?  Let us know why either of the above won't work and I'll 
>>offer some more complex solutions.
>>
>>tester wrote:
>>
>>
>>>There are four files involved in what I am trying to do.
>>>
>>>FILE 1 is the parent to file 2 and contains;
>>>Trip Types, ie , camping, fishing, disney florida, etc.
>>>
>>>FILE 2 is the child of file 1 and contains:
>>>items for each trip type, ie for camping,
>>>pocket knife,
>>>tent,
>>>cooking pan,
>>>propane,
>>>etc.
>>>
>>>FILE 3  is the parent to file 4 and is the clinet list where I select
>>>what trip he/she is interested in.   Once selecting what trip they are
>>>in, a portal from FILE 2 shows up with what they will need for that
>>>trip, ie
>>>camping
>>>pocket knife,
>>>tent,
>>>cooking pan,
>>>propane,
>>>etc.
>>>
>>>FILE 4 is the child  of file 3 and this is where I list the items the
>>>client has actually secured, ie for camping
>>>tent,
>>>propane,
>>>etc.
>>>
>>>I would like to be able to compare FILE 4 (actual items in possession
>>>with) FILE 2 (items needed for trip)
>>
>>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>Howard Schlossberg              (818) 883-2846
>>FM Pro Solutions       Los Angeles, California
>>Associate Member, FileMaker Solutions Alliance
>>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance