Forum Topics Tagged [relationaldatabases]

I am creating a shared database to record requests entered by a team of 30. I need to record the Order Number, Reviewer Name, Date, Action Type(Order Type), Client Name, and a comments box for each order entered. When creating forms, Currently Reviewer Name and Date are auto-input so the reviewer will not have to enter this information. Client Name, Action Type are drop down boxes and Order Number is manual input. All are required inputs excepting the comments field. Can 30 people add to one table all at the same time? Or is a more practical approach 30 tables …

I'm a c++ server side developer, and someone has asked me to write a system for their small business, and I know nothing about the tools available. In fact, Im so out of date in this area, that my first thought was to use Ashton Tate dBase 4! anyone remember that? I need suggestions as to what is the best tool to use to develop a system for these guys. the requirement is for 1) multi user relational database to store customer info. embedded sql interface 2) ability to generate printed reports from the database. 3) I will need to …

Hi there, and thanks first of all for hitting the link i am a beginner in the database world, and found my self required to draw a conceptual model and an Entity Relational Diagram for a Leave Of Absence system. where the system has the following schema: 1-employee request LOA from his manager, 2- loa must approved (accept or reject)first by the manager where the emp is belong to. 3- HR officer approve the approved (accept or reject) loa request after checking if emp has enough day balance. any help will be very appreciated ! Nader

Hello, I am just starting out with ASP.Net using VB.Net. I am trying to build a football website for my football club that has a backend CMS system. I have the database designed with primary and foerign keys in SQL Server 2005. I would like some help to: 1) Insert information into a table containing a primary key ? 2) Get that primary key back and then either insert into a new table with new data or to store the ID in a session ? any help would be much appreciated Thanks

want to build an application that allows a user to build its own form(s). A user can input data into its form and query the data too. the form can be edited after being created and used ( add/remove fields from it ). the form can have fields like: small text box, big text box , single list, check box, drop down menu .... i want to group the fields into tables according to their types... (text boxes will be grouped together in one table, drop down lists in another table and so one ) . I want to design …

I'm currently working on a little project for a friend of mine. He runs a computer shop and needs a small application to register sales and print out a sales ticket. I've done this in Open Office and it works fine (hey, stop throwing things at me!). The problem is that I have to store sales in a database and be able to print out a sales list at the end of each month. I have an idea about a database that holds 3 tables: - customer details - product details - sale details I believe the names are self-explanatory. …