469,944 Members | 2,305 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,944 developers. It's quick & easy.

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 1563
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.

Regards,
Scott
Sep 28 '07 #2
nico5038
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...

Nic;o)
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
By using this site, you agree to our Privacy Policy and Terms of Use.