show only certain data by using IF function?

[***ANDY***]

Hello,

I'm trying to build a database for a motorcycle tour company, after I've spent about 6 hours on a specific topic I better ask the pro's here:

Here's the task:

1. I have one field that contains different tour names, e.g. Wild West Tour, Route66 Tour etc. defined by a value list.

2. I have another field called START that shall contain the start date of e.g. Wild West Tour

3. a separate fp5 file contains all my start dates.

Scoop: If I enter Wild West Tour I want field START to show me ONLY the dates of the Wild West Tour, if I enter Route66 it should only show me the Route66 dates etc etc.

Do I do this by assigning a script to the field START or do I make START type calculation and enter an IF function or something totally different? I tried so many things but couldn't get there yet

can anybody help?

Thanks a lot,

Andy

[Brian C]

You say you have a file that containst the start dates correct?

If so I assume that each of those records containing the dates also have some sort of ID or description for the specific tour to which they belong?

Assuming that is the case you just need to have a relationship that links the TourName in your main table where you are doing the selection, that links to the same matching tour name field located in your StartDates table. Then you just need to make your START field set to use the autoenter option to lookup the date data via the relationship between the 2 tables.

The end result should be that you select an entry from your popup for a specific tour.

(via your value list to the table of start dates)

The START field will then autofill the date because you have a relationship that links the name you just chose to a matching name in your start dates table.

Is this what you were looking for?

[***ANDY***]

Thanks Brian,

yes, in my dates file I have each tour listed in a separate field and every record shows a different date e.g. for my Wild West Tour 5 diff dates.

First I had the dates shown as a value list and not as records but I couldn't get that to work either combined with my main table.

I'll give it a try and see if I can get there. I might get back to you if I can get it work...

Andy