hi -
i know that you can link a database with others and so forth and i got to wondering. i have created a generic database which has a myriad of tables most of which will have the same default values in two controls: "Protocol" and "Title". i would like to be able to minimize the amount of time spent manually keying in the same two values for "Protocol" and "Title" within each database ["Protocol" and "Title" will always have the same values across tables w/in each database, but across databases they won't, e.g. if this too murky:
database_1 database_2
"Protocol" = 00-12-134 "Protocol" = 34-168-038
"Title" = 'Study of Xyz' "Title" = 'Study of aBx'
i got to wondering if it would be possible to create a database having a table with two columns, called "Protocol" and "Title" which could be used to link to the 'Default Value' of the "Protocol" and "Title" fields in each table.
OR -
since, every table in the database has a corrsponding form with the "Protocol" and "Title" controls atop it in the header, if there's some theoretical way to link the two controls on the form with a lookup table in an external database which would require the user to know that database's password...the idea being in this instance to restric the user from changing the values of "Protocol" and "Title" once they'd been entered by an 'Admin' type (someone w/ the password required to enter the external database and choose each's respective value from the combobox of offerings).
i think the first 'idea' is a little unworkable in retrospect and that possibly the 2nd might 'fly'.
any points to ponder?
i know that you can link a database with others and so forth and i got to wondering. i have created a generic database which has a myriad of tables most of which will have the same default values in two controls: "Protocol" and "Title". i would like to be able to minimize the amount of time spent manually keying in the same two values for "Protocol" and "Title" within each database ["Protocol" and "Title" will always have the same values across tables w/in each database, but across databases they won't, e.g. if this too murky:
database_1 database_2
"Protocol" = 00-12-134 "Protocol" = 34-168-038
"Title" = 'Study of Xyz' "Title" = 'Study of aBx'
i got to wondering if it would be possible to create a database having a table with two columns, called "Protocol" and "Title" which could be used to link to the 'Default Value' of the "Protocol" and "Title" fields in each table.
OR -
since, every table in the database has a corrsponding form with the "Protocol" and "Title" controls atop it in the header, if there's some theoretical way to link the two controls on the form with a lookup table in an external database which would require the user to know that database's password...the idea being in this instance to restric the user from changing the values of "Protocol" and "Title" once they'd been entered by an 'Admin' type (someone w/ the password required to enter the external database and choose each's respective value from the combobox of offerings).
i think the first 'idea' is a little unworkable in retrospect and that possibly the 2nd might 'fly'.
any points to ponder?