Relationships
Im having trouble with the relationships for my access db, which i will be using for asp. Ive gone through many tutorials, yet they all keep their db quite simple. I find mine quite complex, so its hard to adapt to them.
Im just wondering if im on the right track or not, cause I have a feeling its completely wrong. The database is used as follows:
The database is use for a training module, users access the training module, and the content is derived from db. There are topics, subtopics, and an assessment area, which is used to test users on their knowledge.
View Replies
how to use related tables in a database, how to retrieve data and how to insert data.
I have one MS access database with two tables. One table contains info about authors and the other contains articles. The relationship between the tables is many to many, that is one article can have many authors and one author can have many articles.
I plan on having a web form where I have the articles written and through the form I need to submit what authors ar related to that article.
What I need help with is how I use the form to connect authors and articles in the database and also how to retrieve the same information to publish on my site using ASP.
View Replies
View Related
I'm trying to build a sort of datagrid control by which i wish to
edit/delete/update data in a table.
Since I'm using foreign-keys for normalizing data in the db I need, when I
add or update data, to display those foreign-keys ID in a user-friendly
manner such as a combobox with values = FK and visible text = Value of the
description field in the related table. Is it enough clear 'till this point?
So I need to detect if a field in a table is related to another field in
another table (i seldom use self-joins, so maybe that would be a limit of my
control but I don't care about that).
Do I have to refer to the Recordset's object OpenSchema method or there's a
better/simpler way to do it?
OT P.S (Off-topic post scriptum.Do you have any suggestions or
advices on companies that work with MS technologies and might be interested
in an ASP/MS Access (included all MS Access non database specific stuff such
as Forms, VBA, Reports) developer with 2 years experience.
View Replies
View Related
Is it possible to access the relationship information from an ASP program? I'd like to be able to traverse the relationship tree of a .mdb file on my server from ASP/javascript code.
View Replies
View Related
When building an Access db to be accessed by ASP, do I need to worry
about setting the Relationships between the tables and the Join Types
(one to many ,etc.), or can I just rely on declaring the relationships
in my SQL statements?
How about the setting for Referential Integrity. Should I ever have to
worry about having Access enforce those, including update and deleted
related records?
I have never bothered with setting the relationships in the couple of
simple databases I've built for ASP. But I always wonder if I should
do that.
View Replies
View Related
Is it possible to access the relationship information from an ASP program? I'd like to be able to traverse the relationship tree of a .mdb file on my server from ASP/javascript code.
View Replies
View Related
can i do this :
rs.Open "SELECT * FROM files WHERE uid ="& getuid , Connect, 2, 3
Even that uid is not a field on files, it is a field on another table related to files..Called Shares.
View Replies
View Related
I have a cross-reference table already set up that contains the information about programs that run in our database. It contains the program name, the tables used as inputs and the tables used as outputs. There is a row for each input to a program and a row for each output from a program. Code:
View Replies
View Related