Oops - need to add "field" to form

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

Guest

Hello. Just finished my (1) form! based on 2 different tables. Relationship set with 1-1 right now "ID". I need to add 2 fields to both the form and the (1) table I forgot to put it in. Is there a simple way to do this. Please let there be - oh please. Can you tell I'm new??? Thanks.
 
Hello. Just finished my (1) form! based on 2 different tables. Relationship set with 1-1 right now "ID". I need to add 2 fields to both the form and the (1) table I forgot to put it in. Is there a simple way to do this. Please let there be - oh please. Can you tell I'm new??? Thanks.
Click to expand...

Stop.

You're almost CERTAINLY going down the wrong track. One to one
relationships are *very* rarely needed, and even if they are, you
ordinarily would not base a Form on a query joining the two tables
(you'ld use a Form with a Subform instead).

It's simple to add the fields - open the Form in design view, view its
Properties, and click the ... icon by the Recordsource property. A
query grid will open; add the field.

But I'd really suggest that you step back and get your table
structures and relationships correct *first*. A working form based on
a flawed table is much worse than a flawed form based on proper
tables, since it's easier to fix!
 
Close all forms and open the table in design view. Add fields as needed.
Close the table and open the form in design view. If you don't see the
fields, open the Record Source property and add the fields.

--
Duane Hookom
MS Access MVP


Niki said:
Hello. Just finished my (1) form! based on 2 different tables.
Click to expand...
Relationship set with 1-1 right now "ID". I need to add 2 fields to both
the form and the (1) table I forgot to put it in. Is there a simple way to
do this. Please let there be - oh please. Can you tell I'm new??? Thanks.
 
Oh boy - guess I need to do more study. Relationships are really throwing my mind curves. I imported 400 records into my table from Excel (began to think this was easy). Tried to add a "field" previously in the source table, but it did not update my "form" just to clarify - both tables have only 1 identical "field" of ID as the primary key in both. Table 2 is just a checklist of 20 items (yes/no) for each person in my main table. Got carried away and forgot about subforms, after studying relationships for so long. Really appreciate this site - thank you. Nik

----- John Vinson wrote: ----

On Sun, 29 Feb 2004 20:11:07 -0800, "Niki" <[email protected]
wrote
Hello. Just finished my (1) form! based on 2 different tables. Relationship set with 1-1 right now "ID". I need to add 2 fields to both the form and the (1) table I forgot to put it in. Is there a simple way to do this. Please let there be - oh please. Can you tell I'm new??? Thanks
Click to expand...

Stop

You're almost CERTAINLY going down the wrong track. One to on
relationships are *very* rarely needed, and even if they are, yo
ordinarily would not base a Form on a query joining the two table
(you'ld use a Form with a Subform instead)

It's simple to add the fields - open the Form in design view, view it
Properties, and click the ... icon by the Recordsource property.
query grid will open; add the field

But I'd really suggest that you step back and get your tabl
structures and relationships correct *first*. A working form based o
a flawed table is much worse than a flawed form based on prope
tables, since it's easier to fix

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=publi
 
Oh boy - guess I need to do more study. Relationships are really throwing my mind curves. I imported 400 records into my table from Excel (began to think this was easy). Tried to add a "field" previously in the source table, but it did not update my "form" just to clarify - both tables have only 1 identical "field" of ID as the primary key in both. Table 2 is just a checklist of 20 items (yes/no) for each person in my main table. Got carried away and forgot about subforms, after studying relationships for so long. Really appreciate this site - thank you. Niki
Click to expand...

If you're coming from Excel, you're probably suffering from
"spreadsheetitis" - which is a healthy, normal state in Excel but is a
debilitating malady in Access! <g>

Excel is a spreadsheet, a good one. Access is a relational database.
THEY ARE DIFFERENT, and require a different mindset.

Just for example, if you have a one (person) to many (checklist items)
relationship, it's good spreadsheet design to have 20 (or 21, or 25)
columns for the checklist. In Access this is emphatically BAD design!

Your Table2 should be tall and thin, not flat and wide: I'd suggest
the following design:

People <your Table1>
PersonID (Primary Key, autonumber or other unique identifier)
<biographical information as needed>

ChecklistItems
ItemNo (Primary Key, manually assigned sequential number or
autonumber)
ListItem (what you're now using as the column header/field name)

Checklist
PersonID <link to People>
ItemNo <link to ChecklistItems>

Rather than putting a checkbox in a *field* in your wide table2, you
would put a ROW into Checklist; this can be done easily on a
continuous Subform by just having a combo box based on ChecklistItems.

The advantage of this approach is that if you have 20 checklist items
today, you might have 24 tomorrow. With the wide/flat approach you
need to change the structure of your table, the structure of any
queries based on the table, and the design and layout of any Forms or
Reports involving that table; with the normalized approach, you just
*add a record* (or four) to ChecklistItems, and you're done; all your
forms and reports will now have these additional items available.
 
John: I have the disease - as you say - made me laugh. Input and directions greatfully accepted. I'm back at square one and giving it another go. Definitely will ck out the live chats. Thanks again
Niki
 
Hi, I have a similar problem. I was trying to create a form in design view and realised that I didn't know how to transfer the fields in my table onto my brand new form. I read this thread and tried to follow it, only to discover that I don't actually know how to set the Record source property. Could someone please give me instructions on how I find it in my Access 2000

Thanks
Tene
 
View the form properties while in design view.

--
Duane Hookom
MS Access MVP


Tenebrae said:
Hi, I have a similar problem. I was trying to create a form in design view
Click to expand...
and realised that I didn't know how to transfer the fields in my table onto
my brand new form. I read this thread and tried to follow it, only to
discover that I don't actually know how to set the Record source property.
Could someone please give me instructions on how I find it in my Access
2000?
 
Hi I tried that but I couldn't see it anywhere in the form properties *confused
Nor could the wizard help me find it

Tene
 
Every form and report have a Record Source property. Make sure you are
viewing the Form properties dialog.
 
Back
Top