Attachment in Form

[Paulo]

I am building a form that contains fields from two tables by using a
one-to-many relationship.

From the 'one' side I am using one text field and one attachment (picture),
all other fields come from the 'many' side into my form.

As I am using the form and enter the info from the one side, I was expecting
the attachment to load up automatically. It will do it only if I refresh
first. Otherwise, I get the following message:

"The current field must match the join key '?' in the table that serves as
the 'one' side of one-to-many relationship. Enter a record in the 'one' side
table with the desired key value, and then make the entry with the desired
join key in the 'many-only' table"

I have tried everything. If anyone can help me I would highly appreciated.

Paulo

 

[Paulo]

I just tried something that works but doesn't solve it. When I am in the form
it looks like there is a conflict between the text field and the attachment.
So I manually attach it to the same file before, and than I enter the text
field, and because now they match I am not getting the error message. Of
course that defeats the purpose of my form. Because I need the form to up
load the image form me and not the other way around.

Does that make sense? How can avoid this conflict between the attachment in
the form and the attachment in the 'one' table?

Thanks Again!

Paulo