Error: 'field' phrase is not found

[chpicker]

I get this error message a lot when trying to set up a list or combo box with a RowSourceType of 6(Fields). It only happens at run-time, obviously, but not during execution of any code (debugger shows no source). Clicking HELP on the error message gives information which is completely irrelevant (something about a command with a PROMPT clause). Is there some kind of secret to setting up a list or combo box that I'm missing somehow?

I want the list box to have 3 columns: 2 fields from one table, and a third field from a child table. I set a relation from the parent to the child in the DataEnvironment object at design time. I have the ColumnCount set to 3, RowSourceType set to 6, and RowSource set to "parent.field1,parent.field2,child.field1". Any ideas?

 

[rgbean]

Normally RowSourceType = 6, uses a single table, and you don't repeat the table name. e.g. RowSource = "parent.field1,field2,field3".

If you are referencing two related tables, you may want to try RowSource = "parent.field1,field2,child.field1" - it may work, if not, consider using a local view that includes both tables as the RowSource.

Rick