Beginner thread, 1 problem when using forms

[c.yyang]

I have a problem when adding items through 1 of the form
i can add records to the table but not through forms

In this file when i add a record through order form, it will show join key .....not in recordset error
I have no problem when adding through other forms such as sandwich form

I am new to this and I cant find a solution after few days
please help me

help.zip

[June7]

Can't enter data into multiple tables through the same query/form.

Use a form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx

[vincent-leeway]

Are you sure, if you have designed your tables properly?

[June7]

Correction to my statement, can edit existing records of multiples tables through a single query for 1-to-1 relationships (I do this). But creating records in related tables through a single query/form does not work, regardless of the relationship type.

Vincent, if you accomplish otherwise, please let us know how.

[vincent-leeway]

Correction to my statement, can edit existing records of multiples tables through a single query for 1-to-1 relationships (I do this). But creating records in related tables through a single query/form does not work, regardless of the relationship type.

Vincent, if you accomplish otherwise, please let us know how.

Now I understood your problem. Well to be honest, I have always used more than 1 query to create a new record or at the best use stored procedures. Never knew that some thing like this could be possible through single query! I would love to do some research to find out, if this is possible.

[June7]

I have a database that tracks laboratory test results. Each sample can have multiple tests performed and the tests vary with type of sample. The easiest structure for data entry purposes is to have a table for each test performed. Sample is logged in and 'header' info goes into the Submit table then a single record for the sample is programmatically saved into individual test table for each selected test. Each test table has a 1-to-1 relationship with Submit table. Workcard is printed, lab techs do testing and enter raw data on workcard. Then the data is entered into db through a single form that has a RecordSource that is a query joining all the test tables to the Submit table. Because of the 1-to-1 relationship, all tables can be edited through one query. The db is not strictly normalized but it suits our requirements.

[c.yyang]

Can't enter data into multiple tables through the same query/form.

Use a form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx

thank you very much, i have solved my problem

[c.yyang]

I have solved the problem by using form wizard instead of just forms

[vincent-leeway]

I have solved the problem by using form wizard instead of just forms

Nice to know that but did you manage to create new rows through single query?