Query-based forms with multiple tables

  • Thread starter Thread starter Andrew Parker
  • Start date Start date
A

Andrew Parker

I am switching to MS Access (2002) after having used Losut
Approach quite successfully and easily for many years. I
had no problem importing all of my data, setting up
tables, and linking them. Where I hit a problem that I
never encountered in Approach was in creating a data-entry
and retrieval form. I was able to set up a query linking
together the various tables I wanted to use, and creating
a form to view that data. My problem is that the form
will not allow me to edit existing records or enter new
ones. What am I missing, and how can I fix this problem?
I would appreciate any help.
 
I am switching to MS Access (2002) after having used Losut
Approach quite successfully and easily for many years. I
had no problem importing all of my data, setting up
tables, and linking them. Where I hit a problem that I
never encountered in Approach was in creating a data-entry
and retrieval form. I was able to set up a query linking
together the various tables I wanted to use, and creating
a form to view that data. My problem is that the form
will not allow me to edit existing records or enter new
ones. What am I missing, and how can I fix this problem?
I would appreciate any help.
Click to expand...

Multiple table queries are often not editable, and - due to the joins
- often confusing for the user in that you'll see multiple repeats of
the "one" side tables' data. Typically one would use Forms with
Subforms for this purpose; a main form would be based on the "one"
side table, and one or more Subforms on the "many" tables.

Access is not Approach. They are both quite capable database programs
but the philosophy and logic is different; they can both access the
data, but they use a different approach. <g>
 
Back
Top