Form from Query will not add or update table data; Form from Table works fine.

[Amyfb]

I have yet to succeed at basing a useful form on a query built on two related tables. I can't find any good information to walk me through how it differs from a form from a table. I don't want to update or append from one existing table to another but I think I have to send the form data to a new table first, and that 's another process I can't find good resources to follow.



Maybe I don't need to worry that I can't do it, but it is annoying the heck out of me that I can't figure it out.

No problem with forms from tables and my simple needs can probably live with this.

But my future could benefit with being smarter.

Thanks in advance for your tips on resources.

my db is too large to upload. sad face.
Cheerios
Amyfb

[ranman256]

is the form bound to the table/query? Thats all it takes to update/add data.

[Amyfb]

is the form bound to the table/query? Thats all it takes to update/add data.

yes it is bound. it's a problem when the query has two related tables. the only field that will accept entry is the first one and auto ID field. all other fields are locked against entry.

if it is just a query against a table alone, no problem, form works either way.

[mike60smart]

Hi Amy

You would normally have a Main Form based on the Parent Table with a Subform based on the related Table

[kd2017]

Is this a 1-to-1 relationship? If not can you describe your tables in question and post the sql?

If so then the problem may be that you defined the 1-to-1 backwards. When defining a 1-to-1 in the relationship window make sure that you click and drag the primary key from the "independent table" to the "dependent table".

[Amyfb]

Hi Amy

You would normally have a Main Form based on the Parent Table with a Subform based on the related Table

Hmmmm, I thought I had tried that, but, I'm game to give it another whirl. Thanks!

[Amyfb]

Hi Amy

You would normally have a Main Form based on the Parent Table with a Subform based on the related Table

Thanks again for the help, Mike. It's a nice hobby you have helping out us newbies!