Connecting Tech Pros Worldwide Forums | Help | Site Map

Automagically add a field to a table

Ken Wilkins
Guest
 
Posts: n/a
#1: Nov 12 '05
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



Larry Linson
Guest
 
Posts: n/a
#2: Nov 12 '05

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]


Bruce M. Thompson
Guest
 
Posts: n/a
#3: Nov 12 '05

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


Susan Pierce
Guest
 
Posts: n/a
#4: Nov 12 '05

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