Connecting Tech Pros Worldwide Help | Site Map

Automagically add a field to a table

  #1  
Old November 12th, 2005, 03:32 PM
Ken Wilkins
Guest
 
Posts: n/a
Is there a way to add a field to a table when the same one is created in
another table? I'm working with keeping track of software for different
versions of OS. If I add a field to the Win98 table, I want it to
automatically add the same field to the Win2k table and the WinXP table. Is
that possible?

Ken Wilkins

--
-----------------------------------------------------------------
Get paid and be healthy! http://www.legacyforlife.net/?site=/ATS
Purchase one-of-a-kind Lampwork Jewelry at www.teaysriver.com

Outgoing mail scanned with Norton Antivirus


  #2  
Old November 12th, 2005, 03:32 PM
Larry Linson
Guest
 
Posts: n/a

re: Automagically add a field to a table


Is there some reason that you are using the tables themselves to substitute
for having data to identify the versions to which software applies? For
example, if all the fields are the same, simply add an OperatingSystem
field, and combine them into a single table. When you want only the
information for a given O/S, use a query with the O/S name as Criteria.

No, there's no automatic way to do what you want, unless you want to write a
VBA sub or function procedure with code to add a field with a name and
properties supplied in arguments.

Larry Linson
Microsoft Access MVP



"Ken Wilkins" <gadget1@verizon.net> wrote in message
news:h8%kb.20228$Ee6.207@nwrddc01.gnilink.net...[color=blue]
> Is there a way to add a field to a table when the same one is created in
> another table? I'm working with keeping track of software for different
> versions of OS. If I add a field to the Win98 table, I want it to
> automatically add the same field to the Win2k table and the WinXP table.[/color]
Is[color=blue]
> that possible?
>
> Ken Wilkins
>
> --
> -----------------------------------------------------------------
> Get paid and be healthy! http://www.legacyforlife.net/?site=/ATS
> Purchase one-of-a-kind Lampwork Jewelry at www.teaysriver.com
>
> Outgoing mail scanned with Norton Antivirus
>
>[/color]


  #3  
Old November 12th, 2005, 03:32 PM
Bruce M. Thompson
Guest
 
Posts: n/a

re: Automagically add a field to a table


> Is there a way to add a field to a table when the same one is created in[color=blue]
> another table? I'm working with keeping track of software for different
> versions of OS. If I add a field to the Win98 table, I want it to
> automatically add the same field to the Win2k table and the WinXP table. Is
> that possible?[/color]

Is there a reason why you have a separate table for each OS? If all the fields
are mirrored in each table, then you should really have just one table for all
that data with one field to identify the OS pertinent to each record.

--
Bruce M. Thompson
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)[color=blue][color=green]
>> NO Email Please. Keep all communications[/color][/color]
within the newsgroups so that all might benefit.<<


  #4  
Old November 12th, 2005, 03:32 PM
Susan Pierce
Guest
 
Posts: n/a

re: Automagically add a field to a table



"Ken Wilkins" <gadget1@verizon.net> wrote in message
news:h8%kb.20228$Ee6.207@nwrddc01.gnilink.net...[color=blue]
> Is there a way to add a field to a table when the same one is created in
> another table? I'm working with keeping track of software for different
> versions of OS. If I add a field to the Win98 table, I want it to
> automatically add the same field to the Win2k table and the WinXP table.[/color]
Is[color=blue]
> that possible?
>
> Ken Wilkins
>
> --
> -----------------------------------------------------------------
> Get paid and be healthy! http://www.legacyforlife.net/?site=/ATS
> Purchase one-of-a-kind Lampwork Jewelry at www.teaysriver.com
>
> Outgoing mail scanned with Norton Antivirus
>
>[/color]

Visit the official MVP site:
http://mvp.org
Susan Pierce MVP


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database design questions David answers 0 June 27th, 2008 05:29 PM
How to insert into joined tables Killer42 answers 21 November 15th, 2006 08:05 PM
How to restrict the number of records added to a table by a subform?? tlyczko answers 6 February 8th, 2006 05:25 PM
Updating table with no key field Zest4Csharp answers 8 November 17th, 2005 04:54 AM