Not able to enter data in form

[Guest]

Hi All,

I created a database to keep track of workshop sales. I am trying to create
a form with fields from 2 tables. The subform is the part that is giving me
the problem. It includes fields from the order form and fields from an auto
lookup query. The first one I created worked fine. I added a total in the
subform footer and now I can't enter any data. I deleted all forms, edited
all relationships, even made a new database with no success. I checked the
properties and everything is set as it should be.....Any suggestions?

Thanks!

 

[Guest]

When you create record source queries with multiple tables, you stand a
chance of creating an uneditable recordset. This is most likely the problem.

 

[Guest]

How can I avoid this? I joined 2 tables with an auto lookup query, fields as
follows:

Products Table:
-Item # (Primary Key)
-Item Description
-Product Line
-Unit Price

Orders Table:
-Order # (Primary key)
-Sortcode
-Item #
-Quantity
-Presenter #

Item Lookup Query:
-Item # (Orders Table)
-Item Description (Products Table)
-Product Line (Products Table)
-Unit Price (Products Table)

The Item Lookup query runs perfectly. I then create a subform for the orders
which includes the following fields:

Orders Subform
-Sortcode (Orders Table and Child field)
-Presenter # (Orders Table)
-Item # (Query)
-Item Description (Query)
-Unit Price (Query)
-Quantity (Orders Table)
-Extended Price (Calculated Control)

In Subform Footer:
Grand Total for Workshop (This field is linked to a calculated control on
the main form.)

This is where it all goes wrong...the query works by itself and the orders
form works by itself, as soon as I combine them it quits working......sooooo
annoying

Thanks for your help!

 

[Guest]

I would suggest you consider a Form/Subform approach. This is how it is
typically done when you have an order entry situation.