Hoosty

it would seem that you could use an if then stament or a case stament to do this. The reason I do not want to create a enitre DB for this and do a relationship is doue to the fact there is on two suppliers I deal with and those suppliers only have at max 3 products. I would like to add some functionality to the database I have just for some extra bells and whistles.

I am trying to create a conditonal list dependent upon the value of a certain field. I have read the other topics in the thread and have not found one that seems to answer this question. Here is a better description of what i am going to attempt to do. I have 2 value list and two fields. Field A and Field B Field A can have two values Value A and Value B now according to which value is placed in Field A determines the value list in Field B. Can some of you gurus please share some of you knowledge to a newbie to this great Filemaker world. Thanks

I got it, but thank you for the scripting lesson

excuse me, it needs to find which day of the week the user specified day is on and not date. My bad

Ok that worked great the only thing is it is not a current date. The field in which I am trying to will be user defined, so it can't be Current date, it would have to go to the field the user sets the date in, see which day of the week that falls on then post the specified date in another field for the status scripting.

When I use that function it places a number in the field I have it set to. Is there a way to have a Left word statement with a loop going thorugh the days of the week, I am not sure about the syntax on this, I am very new to the scripting world of File Maker

Hi everyone, I am trying to create script that upon which day of the week will do a calculation. Once I have the code that will allow me to dtermine which day it is such as "Monday" "Teusday" I will be golden. It has to do this with out using a find function also, if you guys can help me out I woukld be in your favor. Thanks