Re: Sperform question

Bill, As much as I hate to say it, I think the normalisation police might have you "bang to rights" (Brit-slang for "guilty as charged"!). It's a = shame, but perform just doesn't do what you want it to in this case. Someone = who knows more about database theory then me (or maybe someone who was = sensible and stayed in last night) may be able to explain the reasoning behind = this. As far as I know, the only way around this is to have a child table with = the=20 items in, and use a master/detail relationship in perform. Then, each = item would be a separate row in the child table, and perform would have no = problem with the lookup. Cheers, Richard. ----------------------------------------------------------------- =20 | _ =AF\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- >=20 > I have a screen I'm trying to build with sperform, and can't figure > out how to do it, so I turn to you good people for help. >=20 > Table 1: Order > order num > customer num > item 1 > item 2 > item 3 > item 4 > (*Note: normalization police, please don't shoot) >=20 > Table 2: Items > item num > description > price >=20 > I want an sperform screen like this: > (snip) >=20 > When I sformbld this thing, I get errors on f004-f006, > error number is 2892. Is there no way to validate > multiple fields on the screen against the same table? > If I do the validation for one item only, that one item > gets validated just fine. Sperform seems to have a problem > validating multiple entries on one screen against the > same table. >=20 > Any clues appreciated. Thanks. >=20 > ---Bill >=20