P
Paulo
Ok, try this to simulate my problem.
Create a table that has on text field and one attachment field.
Create a second table, and insert the text field column of the first table
into the second table. This will create the relationship.
Creat a query, that has the text field from the second table (the lookup
field that came from the first table), and the attachment of the first table.
When you open the query and try to look up a value for the text field, the
attachment will not come up. There will be an error message saying that "The
current field must match the join key...".
If there a simple solution? By now I am thinking about trying FileMaker or
other program because I am trying to do something really simple.
Help!
Paulo
Create a table that has on text field and one attachment field.
Create a second table, and insert the text field column of the first table
into the second table. This will create the relationship.
Creat a query, that has the text field from the second table (the lookup
field that came from the first table), and the attachment of the first table.
When you open the query and try to look up a value for the text field, the
attachment will not come up. There will be an error message saying that "The
current field must match the join key...".
If there a simple solution? By now I am thinking about trying FileMaker or
other program because I am trying to do something really simple.
Help!
Paulo