Query with two tables

[Michaela]

I have designed a query with 2 tables called "Customers" and "Tanks". The
query has all the fields from tanks which our company rents to customer and
the customer ID [accountnumber] and ship name from customers. Can this query
be used for data entry if a form is made from the query? If it can and is,
how will it affect the main tables? Would appreciate any help and assistance.

 

[NetworkTrade]

a query is showing selected records & fields of the main tables.....any
changes will change the data in the main tables...

 

[Tim Ferguson]

. Can this query
be used for data entry if a form is made from the query? If it can
and is, how will it affect the main tables?

Depends on exactly which fields you include and can see... often you just
have to experiment with Access to see which queries are updateable and
which are not.

In principle:

If the query contains the foreign key (i.e. Tanks.RentedTo) then you can
change _which_ customer is renting the tank but not details within that
customer record;

If you want to update fields within the Customer record, then the query
must contain the referenced key (i.e. Customers.ReferenceID).

But it's not always predictable.

Hope that helps


Tim F