multiple tables in one form

  • Thread starter Thread starter Clay Forbes
  • Start date Start date
C

Clay Forbes

How can i use multiple tables in one form? I have two tables and i
need to use fields from both.
 
Hi,
The usual way is to base your form on a query joining the two tables.
The data in the tables must be related in some way though.
 
I'm trying to figure out the same thing but only with
eight tables. All the technical information I can get is
way too techie for me. I need basic English instruction.
 
Norma said:
I'm trying to figure out the same thing but only with
eight tables. All the technical information I can get is
way too techie for me. I need basic English instruction.
Click to expand...

Create a query joining all of the relevant tables and then bind the form to
the query. Multi-table queries are often not editable though. One with 8
tables is almost guaranteed to not be.
 
I have a query that selects all the tables that i need but when there
is no data entered in the table it causes my form to be blank when i
run it.
 
As I said before, a query with that many tables will almost certainly be read
only. When an Access form is bound to a read only Recordset with no existing
records the entire detail section becomes blank. This is because there is no
current record to display and the "blank" record you normally see is actually
the "new row" placeholder which is not available on a read only recordset.
 
So, is there any way to make a form bound to 2 tables without making
it read-only? Also without making the screen black.
 
Clay Forbes said:
So, is there any way to make a form bound to 2 tables without making
it read-only? Also without making the screen black.
Click to expand...

As stated, the detail section of a form with no records to show and no
ability to add new ones will be completely blank. If you want to provide
something for the user to close or re-filter the form place those controls
in the form header or form footer. These will still be displayed in the
aformentioned scenario.

There is an entire help topic in Access about when queries are updateble or
not. I'd suggest you look at that. In some case a multitable query can be
tweaked so it will be editable. In other cases not. With only two tables
in the query it should be possible. As the number of tables grows it
becomes more difficult to achieve.

A word of warning though. In some cases a multi-table query that DOES
allow editing might not affect the underlying tables in the manner you
expect. This has to be tested out before turning it loose on users.
 
You might have allready answered this question, and if you have sorry.
Is there any other way (besides queries) to put multiple tables on one
form and be able to edit them. This is my first access project and
using a query to access multiple tables on one form seems to create a
lot of problems for me.
 
Clay Forbes said:
You might have allready answered this question, and if you have sorry.
Is there any other way (besides queries) to put multiple tables on one
form and be able to edit them. This is my first access project and
using a query to access multiple tables on one form seems to create a
lot of problems for me.
Click to expand...

Use subforms. Then each subform and the parent form is only bound to a
single table each. I have almost no instances where I attempt to edit a
multi-table query.
 
Ok, How do I make the tables in the query editable like you said? I
looked in the help section of acces but could not find anything on how
to make tables editable in a multi-table query. Also, How can i make
it so that the blank screen does not show up even when there is no
data in the table?
 
I can't use the subforms because it takes up too much room and has
borders that can not be removed.
 
Back
Top