Looked-Up Value Problem

[APost]

I'm managing photographs for catalog project and have a lookup problem. My root table is the book table that lists each catalog I'm shooting.

Then there is related table for pages in the book. In that table are three fields of interest. The temporary page number that the client provides, the name of the spread as it will apear on the corner of the page (like 1-2 3-4 etc) and a due date for each spread

The other related table holds each photograph that needs to be produced.

I have a drop box populated with temporary page numbers the are realted to the current project and that works great.

Then I have FM lookup the value for Sprea and due date based on the value of the temporary page.

Now it get's wierd. If I select in the drop Box values 40HE001 through 40HE011, then I get no values returned. If I select the next, 40HE013, or any up to 40HE045, the lookup values change appropriately. When I get to value 41HE001, things go south again until I get to value 42HE001. It doesn't seem to make a difference if I define this as either a text or a number field.

It looks like FM doesn't like my client's naming convention for their temporary page numbers, but I can't change that. Any ideas?

[APost]

I just noticed that it was updating the sequential value IDPage properly, but didn't notice that the IDPage values were not from the current book. I added that to the relation ship and all is well.

It reminds me of a poem I saw in someone's cubicle at TI.

I really hate the **** machine

I wish that they would sell it.

It never does just what I want,

But only what I tell it.

FM was looking up the temporary page number from a PREVIOUS project. One that had no page or due date values entered and was doing just what I asked it to.

In the words of Emily Latella, "never mind"