Tables/Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a basic form using the wizard and now I need to add some fields
from another table - how do I access the other tables that I want to use?

Thanks

Anthea
 
Anthea, first create a query based on the tables that you want to use on your
form then use the wizard to create the form based on that query.
 
Don wrote:
Anthea, first create a query based on the tables that you want to use
on your form then use the wizard to create the form based on that
query.
Click to expand...

Keeping in mind that a query with multiple tables in it will not allow
updates to its data set unless it is set up "just right".
 
yep, thats right!
--
Don


Rick Brandt said:
Don wrote:



Keeping in mind that a query with multiple tables in it will not allow
updates to its data set unless it is set up "just right".
Click to expand...
 
Is there no other way to access the other tables that I want to use? I have
already created the majority of the form the way I want it to look.

Thanks

Anthea
 
Or, if you just want to grab a value or two from another table strictly for
reference/display: DLookup, DCount, etc. in a textbox.
 
Is there no other way to access the other tables that I want to use? I have
already created the majority of the form the way I want it to look.
Click to expand...

If you designed the form first, and then started thinking about
tables... you're working backwards! That's like assembling your house
walls and roof and then thinking about where to pour the foundations.

The tables are PRIMARY - you need to design the forms to fit the
tables, not vice versa. A Form for multiple tables will typically have
a Form based on the "one" side table in a relationship, with one or
more Subforms for the "many" side tables. If you don't have
relationships defined, well... you need to.

To directly answer your question, you *cannot* simply start adding
fields to a form from this table or that table. Forms just don't work
like that!

John W. Vinson[MVP]
 
Anthea, illustrate for us what you want on your form eg: Customers,
CustomerOrders etc. A main/sub form setup is the quickest and easiest method
to bring multiple tables together in a form. Sounds to me like you've created
your form from a parent table (eg:customers), now you need to insert on that
form a subform from a child table (eg: customerorders). You'll need in the
child table a foreign key (CustomerID) that references to the parent table.
This will provide the link between the main form and subform.
 
It depends on how the information in the 'other table' relates to the
information in the first table.

It is possible to base your form on a query, but that could result in you
not being able to add any records.

If the 'other table' is related to the first table, you may find that using
a subform for the 2nd table is appropriate.

Can you describe your tables?
 
Joan,

I have the following tables:

Company Information - contains name, city, state, etc
Company Type - business type
Contract Specifics - effective date, term, etc
Management Contact - name, tel, email
Operations Contact - name, tel, email
Technical Contact - name, tel, email
Customer Service Contact
Mgmt Software - software used
Client Paperwork - last audited, updated, etc
StateList - state abbreviations.

I know I can just re-create the form with the info that I want, but I was
hoping there was a way I could just add in information from tables that I
have not used on the existing form I have created.

For example, at the moment, I have info on my form from the Company and
Contract Specifics tables. I would like to add in info from the various
Contact tables, without having to recreate my form, if at all possible.

Anthea
 
You should consider putting all the Contacts into a single table. You could
add a field to indicate what type the contact is (Management, Operations,
Technical, or Customer Service). This would be related (M to 1) to the
Company table.

You could then just put a subform on your existing form, to list the
Contacts for that company.

But to answer your question, if you open your form in design view and View,
properties, you'll find a property called Record Source. It's likely a
table or a SQL statement. In either case, click on the build button (...)
to the right of that property, and add the table(s) and field(s) you want.

Then after closing and saving that, you'll return to design view, where you
can drag the new fields from the field list to your form.
 
Back
Top