Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Where is the form I just created?
- Thread starter Teaa
- Start date
Hi Teaa,
Assuming that you set the form's record source to the query you are using, the query relationships have to linked using primary keys that are the same for each table for changes to affect the tables.
For example, you could have "SystemID" as you primary key in a table, and another table with fields "SystemID" and "System Name". You would need to left join the tables with "SystemID" for you to be able to update the tables from the query.
You might consider using subforms for each secondary table. You can look up subforms in Help and the various ways you can use them as you didn't specify exactly what you are trying to do. This might be the easiest way to go
Hope it works out
Assuming that you set the form's record source to the query you are using, the query relationships have to linked using primary keys that are the same for each table for changes to affect the tables.
For example, you could have "SystemID" as you primary key in a table, and another table with fields "SystemID" and "System Name". You would need to left join the tables with "SystemID" for you to be able to update the tables from the query.
You might consider using subforms for each secondary table. You can look up subforms in Help and the various ways you can use them as you didn't specify exactly what you are trying to do. This might be the easiest way to go
Hope it works out
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
