How do I input to a form that has fields from linked databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with Access 2003. I have 3 tables that I've linked. I now want
to create a form to present different fields from the 3 tables. I want some
of the fields to be input fields with a drop down menu.

My problem is that it does not appear that Access will let me input into
fields on a form that has been created with linked databases.

If I create a form with just one database, I can input via drop down.
However, as soon as I bring in data from another table (via linking), the
data input fields lock.

Any suggestions?
 
That's joining not linking. Multi-table joins are updatable in most
circumstances. If your problem is not one of the following, look up
"updatable joins" in help and in the knowledge base for other ideas.
1. Join type must be inner, left, or right. Cross joins and unions are not
updatable.
2. Tables in the join should have primary keys defined so that Access can
determine the cardinality of the relationship.
3. Queries must not contain aggregate functions such as First(), Max(),
Avg(), Sum(), etc.
4. Crosstab queries are not updatable.
5. Joins of three or more tables must be hierarchical or lookup
relationships. Multiple unrelated 1-many joins produce Cartesian products
(cross joins) and so are not updatable. An example of a hierarchical
relationship is Customer --> Order --> OrderDetails <-- Product. The first
three tables are hierarchical and the Product table is a lookup. An example
of two separate 1-many relationships is Student --> Class and Student -->
Parents. A query that joined Student, Class, and Parent would not be
updatable because parents and classes have no logical relationship to each
other even though they both contain the StudentID.
 
Back
Top