472,142 Members | 1,162 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

Is it possible to use multiple tables in a single form?

Is it possible to use multiple tables in a single form without using sub-forms? I want to be able to input information that goes to multiple tables at the same time. I can post a design of what I'm trying to achieve if necessary.
Sep 28 '07 #1
2 1629
Scott Price
1,384 Expert 1GB
Generally speaking this is what SELECT queries are for.

Here are two articles that are helpful to understand the syntax: Basic SQL Syntax for Access Queries and SQL JOINS.

Sep 28 '07 #2
3,080 Expert 2GB
The general approach to this is to use a so-called "unbound" form and issue the needed insert/update by code.

Personally I don't see the point of not using subforms, as that's easier and when using a "single form" view and no borders, the users won't be able to tell that there are subforms used.

I also suspect that you're trying to store "redundant" data, as this type of Q often "hides" the storing of totals in separate tables. Such an approach is "not done" in a real well designed database.

For more info you'll need to supply us with more information...

Sep 28 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Greg Neef | last post: by
11 posts views Thread by dskillingstad | last post: by
3 posts views Thread by CAD Fiend | last post: by
12 posts views Thread by Peter Proost | last post: by
8 posts views Thread by Daniel | last post: by
7 posts views Thread by =?Utf-8?B?TG9zdEluTUQ=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.