Table or Query?

B

BaDonkaDonk

I have my database ready to go and when I go into forms to set that up I get
asked the question if I want to use the information form a table or a query.
I am not sure which is the best route. I have 3 different tables I want to
link together into one form. I tried using just a query to make my form and
I ended up with a blank form. So then I tried using the table set up for my
form and again I got nothing. Should I mix both the tables and queries?
 
S

SusanV

Add the three tables to a query, select the fields you will need on the
form, then base the form on the query. (Tables must be joined, I'm assuming
you have already setup your relationships)

hth,
Susan
 
A

Arvin Meyer

You must use an updateable recordset to be able to edit/add data in your
form. The means you must have the key from the table you want to edit. I
have seen occasional forms that make use of 2 editable tables, but it is
rarely required except with form/subform data. It is well beyond the scope
of a newsgroup answer to be able describe the process of using the different
conditions and techniques so I suggest you get a good book on Access that
has some basic instruction. One I often recommend is John Viescas' Access
2003 Inside/Out:

http://www.amazon.com/exec/obidos/A...linc?creative=327641&camp=14573&link_code=as1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
S

Sprinks

Hi.

"Design View" is the default when creating a new form. Clicking OK after
choosing your record source (a table or query) causes Access to start a blank
form in design view. You can then place any or all of the fields from the
record source specified.

Or, choose "Form Wizard" after specifying your record source and it will
walk you through it. What source you choose depends on the nature of your
data, and how you want to display it. If you wish to show all the orders of
a specific customer, for example (a one-to-many relationship), a main form
based on the Customer table and a continuous subform based on Orders would be
appropriate. The subform is "linked" to the main form by its
LinkMasterFields and LinkChildFields properties, which specify the field in
the main and subform's record sources respectively that has the matching
data, in this case, CustomerID.

You may use either a table or a query, but be aware that some multi-table
queries are "non-updateable", usually because changing the data in them would
violate Access data integrity rules. A Google search on this topic will
provide more information. The way to check a query for "updateability" is to
open the query itself and try to change data.

Hope this helps.
Sprinks
 
B

BaDonkaDonk

I set up the query and went to make my form and it keeps coming up blank, in
the design view there is information but when I go into the form view I get
no boxes.
 
S

SusanV

Sorry I don't understand what you mean. Does the query return records when
viewed in datasheet?

Susan
 
B

BaDonkaDonk

Susan,

That query returns nothing when it's in the datasheet. It is a blank
screen. I thought maybe it was something I did in one of the tables but when
I did each table seperately data showed up in the datasheet, but not when all
the information is on one form.
 
S

SusanV

Then the query criteria or the relationships are setup wrong. Without more
info about your table structure and relationships, and the query itself I
can't tell you what is wrong...

Susan
 
A

Arvin Meyer

BaDonkaDonk said:
Susan,

That query returns nothing when it's in the datasheet. It is a blank
screen. I thought maybe it was something I did in one of the tables but when
I did each table seperately data showed up in the datasheet, but not when all
the information is on one form.
Click to expand...

There are no records in the recordset that the query returns and the
recordset is not updateable, so you'll get a blank result. As I said before,
you need to build an updateable recordset in order to edit records. Your
query is also suspect since it returns nothing. Post the key structure of
the tables and write a question in plain english and we may be able to write
an updateable query for you. Just type the structure in, do not attach any
files.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top