Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-31 : 16:55:47
|
David writes "OK, I'm quiet new to ASP (being from a PERL background) but I am trying very hard to learn. I have been given the task of creating an Intranet system for my company that has to have a fault reporting system enabled, using PWS and MS Access 2000.
Here is what I am trying to do; tblFaultDescriptions has 3-fields, FID (primary key), Fault_Brief and Image. The first is the Primary key and is set to autonumbered. The second contains a small amount of text such as "Flash movie problem" and the final one contains the name of an image that is related to the Fault_Brief (a nice MM Flash icon with an 'X' through it for this example).
Now, when someone adds a report (logs a fault), they have a drop down menu entitled: Fault Description, which is generated from tblFaultDescriptions from the db and the OPTION VALUES are equal to FID from the table.
With me so far? Great...
Right, I want people to be able to list all the outstanding faults and when they see them, the nice pretty icons are next to them and they are headed with the text from the tblFaultDescriptions table from the cell called, Fault_Brief (the table that holds the fault reports would be called tblReports and contains information such as, UID (Pkey), User_ID, Fault_Brief (or FID from tblFaultDescriptions), Date_Open, Date_Closed...etc etc....).
What is needed here is something that says, "Right, print out all the records in tblReports and if any of them have something saying 'Flash Movie problem', show the correct icon for it, and print the text in the Fault_Brief field from tblFaultDescriptions." - Bear in mind that there will be more than one Fault_brief and more than one associated image for it.
Easy? I am probably asking something that is standard, but I have been going mad trying all sorts of SQL queries! Please, please advise!! I just cannot seem to get data from two tables and cross-reference themselves going by an IF...THEN type of thing. No hard-coding can be done on the html file because the tblFaultDescriptions table will be edited often via another web-interface.
Thanks for even reading this far, you are a diamond!
--
Davidj.
" |
|
|
|
|
|
|
|
Cross-referencing data from different tables.