By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,894 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,894 IT Pros & Developers. It's quick & easy.

Automagically add a field to a table

P: 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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <ga*****@verizon.net> wrote in message
news:h8*****************@nwrddc01.gnilink.net...
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

Nov 12 '05 #2

P: 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?


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
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #3

P: n/a

"Ken Wilkins" <ga*****@verizon.net> wrote in message
news:h8*****************@nwrddc01.gnilink.net...
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


Visit the official MVP site:
http://mvp.org
Susan Pierce MVP
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.