queries

MK1999

New member
Local time
Today, 02:52
Joined
Mar 30, 2022
Messages
24
I want to create a form that will show to the user the record information (from multiple tables) and the user can modify it.. i tried to create one query including all the information but it become not updatable..
im now thinking to divide the query to multiple queries that will return all the required data and then create a macro that calls all the queries in the form.. is this possible? and how to write the macro statement.
 
you must first, identify which fields in your tables are the Primary key and the Foreign key.
then you Join each table by its PK and FK key to make them updateable query. dont use Inner join.
 
I think it would help if we knew more about your db. It's purpose. Tables it has and the relationships between the tables.
Perhaps you could show us a screen shot of your Relationships Window with a brief description of the db.
You could also post the db with a description.
 
you must first, identify which fields in your tables are the Primary key and the Foreign key.
then you Join each table by its PK and FK key to make them updateable query. dont use Inner join.
can i see example for the join with PK, FK? currently its automatically using inner join
 
see Person and Jobhistory table in design view.
see Query1 joining these tables.
 

Attachments

It isn't the specific join type that will make a query not updateable, it is mixing them in certain ways when you are joining 3 or more tables. For any two-table join, left, right, or inner all work fine.
 

Users who are viewing this thread

Back
Top Bottom