Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2005

Tip: Looking for answers? Try searching our database.

How do I link a record to a column in another table?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PaulNaude - 30 May 2005 15:01 GMT
I would like to know if it is possible to link records in one table to
columns in another with standard db design (i.e. without coding the addition
or removal of a column when the applicable record in the table is deleted).

I do not want to use a many to many relationship for this specific example
in order to simplifly the procedure for the user:

I Have equipment and each type has applicable parameters. If the user add a
new parameter to the list of paramereters, he has to select in another table
to which types of equipment this parameter applies.
I.e., in the list of equipment types, there should be YES/NO columns for
each parameter from where to choose wheteher it is apllicable or not.
So, if the list of parameters change, so must the columns in this table.

It will be easy by forcing the user to use a form for the deletion and
addition of parameters (where underlying code can then do the rest) but since
I will be accessing the database from another program (VB.NET application), I
would like to the design the db in such a way that I do not need a form to
make the neccesary changes (or would it be possible to use the db's form in
my application in such a way that it seems part of my application?)

Any ideas?
John Nurick - 30 May 2005 22:07 GMT
>I would like to know if it is possible to link records in one table to
>columns in another with standard db design (i.e. without coding the addition
>or removal of a column when the applicable record in the table is deleted).

It's not possible.

>I do not want to use a many to many relationship for this specific example
>in order to simplifly the procedure for the user:

Like it or not this *is* a many to many relationship between equipment
types and parameters.

>I Have equipment and each type has applicable parameters. If the user add a
>new parameter to the list of paramereters, he has to select in another table
>to which types of equipment this parameter applies.
>I.e., in the list of equipment types, there should be YES/NO columns for
>each parameter from where to choose wheteher it is apllicable or not.
>So, if the list of parameters change, so must the columns in this table.

It's highly undesirable and never or virtually never to alter the design
of tables as part of ordinary database operations.

>It will be easy by forcing the user to use a form for the deletion and
>addition of parameters (where underlying code can then do the rest) but since
>I will be accessing the database from another program (VB.NET application), I
>would like to the design the db in such a way that I do not need a form to
>make the neccesary changes (or would it be possible to use the db's form in
>my application in such a way that it seems part of my application?)

ISTM that the best approach would be to implement the m:m relationship
with a joining table as usual, and then code a user interface on a
VB.Net form.

>Any ideas?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
John Nurick - 31 May 2005 23:11 GMT
>It's highly undesirable and never or virtually never to alter the design
>of tables as part of ordinary database operations.

...or virtually never necessary...
--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.