Update queries

[ezz]

Hi,



How can I update all the queries when I enter a new record in a form?

When I enter a new employee record in a form, I want all the queries that are related to the employee information table to be updated with this new entry.

Thanks.

[orange]

see this for basics of Access objects

[June7]

Data entry/edit is automatically reflected in all query objects using the table being edited.

[Demerit]

Data entry/edit is automatically reflected in all query objects using the table being edited

Except for quries that have a one-to-one relationship and a related record is not found in all the tables concern.

[June7]

That would depend on the join type - for an INNER join, yes. INNER JOIN requires related records on both sides for data to show in query for any type of relationship.