Sorry about that.. I'll provide more detail.
Here are two tables. Table 1 and Table 2.
Table 1:
ID----field1----field2
1 -----one----- monday
2 -----two-----tuesday
3 -----three-----wednesday
Table 2:
ID-----field1
1 ------ january
2 ------february
3 ------march
I want to do a lookup in Table 1 field 1. So... using the lookup wizard I choose table 2 as my source table and Table 1 field 1 to place my lookup values. Obviously the ID fields in both tables serve as a common value to do the lookup against.
As a result of my lookup, I would expect to see in Table 1 the below:
Table 1:
ID----- field1----- field2
1 ------january------monday
2 ------february------tuesday
3 ------march------wednesday
But instead I see the same old Table1 without the new lookup values cascaded into field1. But.. I don't. Instead, when I click on any field 1 value I get a combox with a list of the table2 values in it.
If, when I step through the lookup wizard, I select (at the last step) to 'cascade results and enforce referential integrity' I get an error 'THE TABLE COULD NOT BE SAVED'.
I, at the very least, wanted to see the new values displayed in Table 1 field 1 corresponding the the values in Table 2 field 1 where Table1 ID = Table2 ID.
Why are these results not displayed. Why do I get this error ('the table could not be saved') when I opt to cascade the results?
